Mining Model Viewers - SQL School Video
In this video MVP Brian Knight explains how you can use the model viewers to see how the data mining task will process your data.
2009-02-05
2,053 reads
Articles
All the Aggregates you crave with Grouping Sets in SQL Server 2008
As reporting requirements increase, it seems that aggregate functionalities have thankfully risen to the occasion concurrently. To maintain its competitive edge as Staples Canada’s best vendor, BaldGorilla, where I’m currently consulting, has been able...
2009-02-05
2,050 reads
Creating packages in code - OLE-DB Source to Raw File Destination
This code sample programmatically creates a package with an OLE-DB Source and a Raw File Destination, and the resulting package exports data from SQL Server to a raw file. The finished package just has the one Data Flow Task shown below.
2009-02-05
2,139 reads
Where is the Surface Area Configuration tool in SQL Server 2008
I just installed a new instance of SQL Server 2008 and I can't find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Database Engine features in SQL Server 2008?
2009-02-05
4,065 reads
SQL Function : Find ‘X’ Business Days in the Future
Many of us deal in date calculations and separating business days from calendar days is always a challenge. New author J Gravelle brings us a new article that talks about this subject as a way of ensuring SLAs are met.
2009-02-04
10,828 reads
Gaining the benefits of DMVs for SQL Server
Dynamic management views help monitor SQL Server health and tune performance. Learn how to use DMVs to retrieve critical data on the internal workings of SQL Server.
2009-02-04
3,381 reads
Ruthless Focus - A Different Type of Time Management Philosophy
If you could list all the reasons I work, the number one reason would be to support my family. My definition of support includes spending an appropriate amount of time with family, not just working to support it. I suspect most of you would agree with that as a goal.
2009-02-04
1,886 reads
SQL Server Version
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
2009-02-04
3,287 reads
Installing Sample 2008 Databases - SQL School Videos
Installing the sample databases in SQL Server 2008 isn't as straightforward as in previous versions. Brian Knight shows what needs to be done in this video.
2009-02-03
3,926 reads
CreationName 2005 - Adding components programmatically
If you are building packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post.
2009-02-03
1,319 reads
Blogs
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers