Suspect Database
Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to...
2011-12-19
492 reads
SQL Server 2012 Diagnostic Information Queries (December 2011)
Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to...
2011-12-27 (first published: 2011-12-19)
3,653 reads
Junk dimensions
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might...
2011-12-19
1,386 reads
Pitching Pebbles – Using Certificates to Grant Privileges
If you fill the jar with pebbles first, you'll never have room for the big rocks.
I’m sure you’ve heard the...
2011-12-19
1,219 reads
SELECT GetDate() – 30 AS [This actually works??];
I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....
2011-12-19
1,235 reads
PASS Summit 2012 Evaluation Results
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...
2011-12-19
1,735 reads
CONCAT() string function–SQL Server 2012
As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...
2011-12-22 (first published: 2011-12-19)
4,006 reads
SharePoint Reports and Scorecards on Apple Devices
While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple...
2011-12-19
711 reads
Contracting is business not employment: Read the small print
This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to...
2011-12-19
1,209 reads
Read About SQLSatuday #100 & See the Coffee Cup Too!
Here’s a great post from Karla Landrum about her trip (with husband Rodney) to Brazil for the milestone making #100....
2011-12-19
732 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