sql server 2008

Welcome to the 'sql server 2008' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'sql server 2008'.

Latest blogosphere posts tagged “sql server 2008”

• Table Variables – still a mystery

  
  SQLServerPedia — Authority: 146
  Geeking with table variables. Again.     Table variables have always been somewhat interesting to work with when developing in SQL Server. I remember when they came out in SQL Server 2000 we were all excited about trying them out, something new from SQL 7 that mainly sparked our interest I suppose. I mostly ...
  3 days ago

• SQL Server 2008 Diagnostic Information Queries (Late November 2009)

  
  Glenn Berry's SQL Server Performance — Authority: 421
  Here is the latest version of my Diagnostic Information Queries for SQL Server 2008.  Running these queries will give you a pretty good idea about the configuration and health of your server and about any particular databases on the server. I have added several new queries this time, and tweaked many of the ...
  5 days ago

• Some Ways To Look For Things in SQL Server Modules

  
  Glenn Berry's SQL Server Performance — Authority: 421
  If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it can sometimes be difficult to keep track of whether you have used certain options (such as RECOMPILE).  The queries below show some different things you can discover by querying sys.sql_modules and ...
  6 days ago

• Microsoft SQL Server 2008 Bible by Paul Nielsen, Uttam Parui

  
  Free Your Mind All Free Download — Authority: 164
  Microsoft SQL Server 2008 Bible | Wiley | 2009 | ISBN: 0470257040 | 1680 pages | PDF | 31 MB Get ready for SQL Server 2008! Whether youre a database developer, DBA, or BI Developer, SQL Server 2008 promises to change the way you deliver enterprise data solutions. Open this detailed, experience-based guide for clear ...
  6 days ago

• StreamInsight talk coming up at SQLBits

  
  MSMVPS.COM — Authority: 650
  My talk on StreamInsight is up next. I’ll try to blog more about that later. For now, I want to mention more about SQLBits itself. This is by far the largest SQL-only conference I’ve attended (I haven’t been to SQL-PASS yet), and it’s great to be involved. Yesterday I had an all-day seminar about the ...
  1 week ago

• AppDev SQL Server Integration Services 2008 DVD-iNKiSO

  
  FileBeta — Authority: 147
  This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, ...
  1 week ago

• The Planet Joins Microsoft WebsiteSpark™ Program

  
  The Web Hosting News — Authority: 425
  (The Hosting News) – HOUSTON – The Planet, the global leader in IT hosting, today announced its membership in the Microsoft WebsiteSpark program. Through this partnership, The Planet provides small Web development and design firms with free Microsoft licenses for the latest versions of Windows Server and SQL ...
  1 week ago

• Record of a PSS Call

  
  Home of the Scary DBA — Authority: 125
  Not everyone has the opportunity to call Microsoft Premier Support. For those who have not yet had this experience, I’ll document my most recent, non-critical, call. Critical calls are a different critter entirely. We were experiencing a very odd error on one server in our system. When a particular procedure was ...
  1 week ago

• Cumulative Update 5 For SQL Server 2008 Service Pack 1

  
  Glenn Berry's SQL Server Performance — Authority: 421
  Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 1 .  You can go here to request the hotfix from Microsoft. It typically takes just a few minutes for them to send you the download link and password, then you have to download and unzip with the password. This CU is Build 2746, and there ...
  1 week ago

• SQL Server 2008 iFTS Lessons Learned

  
  Glenn Berry's SQL Server Performance — Authority: 421
  We have been using SQL Server 2008 Integrated Full Text Search (iFTS) in Production at NewsGator for a little over a year, with very good results. We were able to replace a 3rd party solution that required a lot of attention, maintenance, and extra hardware, with a very simple iFTS implementation that is much easier ...
  1 week ago

• SQL Server MVP Deep Dives Book Signing At PASS Summit

  
  Glenn Berry's SQL Server Performance — Authority: 421
  Kimberly Tripp posted today about the SQL Server MVP Deep Dives book signing event at PASS on November 4. The PASS bookstore sold out of all of their copies of the book (150 in all), and many people who bought the book waited patiently in a long line to have many of the authors sign their copy. Kimberly ...
  1 week ago

• Download Free E-book: Introducing Microsoft SQL Server 2008

  
  ProgrammerFish - Everything that's programmed! — Authority: 426
  Introducing Microsoft SQL Server 2008 by Peter DeBetta is now available to download for free. You can view the first chapter before downloading the whole book. The Objective of this book is not to give in-depth view of the new features of SQL Server 2008 but to help people begin to grasp what can be [...] ...
  1 week ago

• Using Dedicated NICs to Segregate SQL Server 2008 Backup Traffic

  
  Glenn Berry's SQL Server Performance — Authority: 421
  If you need to initialize a mirrored database for SQL Server 2008 Database Mirroring, one of the first things you have to do is take a full backup of the database that you want to mirror. You can either back it up locally and copy the backup file(s) over the network to the server where you are going to mirror it, or ...
  2 weeks ago

• Why We Recommend Against xp_cmdshell

  
  K. Brian Kelley - Databases, Infrastructure, and Security — Authority: 110
  Every so often I see a post in a forum or on  Twitter about the use of xp_cmdshell. Usually it is someone looking for a reference as to the security risk of doing so. So lets look at what using xp_cmdshell means. In SQL Server 2000 we used to have a recommendation to drop the extended stored procedure if you ...
  2 weeks ago

• Microsoft Project Madison

  
  Software Ruminations — Authority: 125
  Project Madison is a new Data Warehousing solution from Microsoft, born out of their purchase of DATAllegro in August 2008. It is a: “highly scalable data warehouse appliance that delivers performance at low cost through a massively parallel processing (MPP) architecture.” It’s official name is “Microsoft ...
  2 weeks ago

• SQL Server 2008 Database Mirroring in Action

  
  Glenn Berry's SQL Server Performance — Authority: 421
  I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800 and four Dell PowerEdge 1950 servers that were running a number of busy, large SQL Server 2008 databases. We had previously done some vertical partitioning (splitting different application functionality across ...
  2 weeks ago

• Microsoft SQL Server 2008 R2 Enterprise Evaluation November CTP DVD-LiBiSO

  
  FileBeta — Authority: 147
  The R2 release brings significant new capabilities and enhancements that can help your business keep pace with todays growing and changing data management needs. Increase productivity and reduce data management costs by taking advantage of an even more scalable platform with comprehensive database and application ...
  2 weeks ago

• SQL Server Wish: Last Logon Information

  
  K. Brian Kelley - Databases, Infrastructure, and Security — Authority: 110
  The other day my wife and I were driving around and noticed that a Little Caesars location had shown up near our house. The kids love their pizza and at the price, you cant beat it. So we decided after karate tonight that wed pick up pizzas from there and head home to consume the delectable product. So we do just ...
  2 weeks ago

• SQL Server 2008 R2 Enterprise Evaluation November Download

  
  Bink.nu — Authority: 567
  SQL Server 2008 R2 November CTP has numerous new and enhanced features. This document provides the information you need to fully take advantage of these features. For Analysis Services, numerous enhancements have been added to the PowerPivot field list. These include automatic relationship detection when columns ...
  2 weeks ago

• SQL Server Wait Type Repository

  
  Glenn Berry's SQL Server Performance — Authority: 421
  Microsoft’s Bob Ward has a good pos t up on the CSS SQL Server Engineers blog about an upcoming web page that will completely document all of the wait types from the sys.dm_os_wait_stats DMV. There will be more detailed and practical information about the individual wait types compared to what is documented in ...
  3 weeks ago

Comments about sql server 2008