Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions
SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than...
2011-08-02
634 reads
SQL Server Functions- An Introduction
SQL FUNCTION: -
Function in a database can be defined as the code segment consisting of a logical group of SQL...
2011-08-02
2,991 reads
I deem September 2011 – SQL Server Month
If you haven’t visited the SQL Saturday website you should take a look. There are SEVEN events planned during September around...
2011-08-02
557 reads
PowerPivot Gallery Error Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’
Oh no you, you got the Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ error!!! What to do now? Why did you get...
2011-08-02
1,065 reads
Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings
We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...
2011-08-02
15,681 reads
Minnesota SQL Server Study Group (August)
Last month, I started using Meetup to schedule SQL Server Study Group events. The idea is to meet twice a...
2011-08-02
946 reads
Fitting In-The Editorial
This editorial I wrote ran on SQLServerCentral a couple weeks back and generated a lot of comments, and more than...
2011-08-02
305 reads
LAG’n’LEAD – New T-SQL Features in SQL Server Denali CTP3
Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row, or...
2011-08-02
1,721 reads
August Monthly SQL Server Checklist
First day of the month and first Monday of the month. The list is coming out a bit late due...
2011-08-02
802 reads
Recruiting for “Women In Technology” panelist for Oregon SQLSaturay Oct 8th, 2011
We are recruiting panelists for a “Women in Technology” discussion at SQLSaturday Oregon. SQLSaturday is an all-day free training event...
2011-08-01
564 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers