A Few Useful Queries for SQL Server 2008 Integrated Full Text Search (iFTS)
I had a hardware issue this past weekend on one of my database servers where I am running SQL Server...
2010-01-18
1,544 reads
Database Design Process
Buck Woody recently asked a question; how do you design a database. He outlined the process he followed and asked...
2010-01-18
1,917 reads
Accidental DBA?
It seems to me that over the last year or so that there has been an explosion in the use...
2010-01-18
651 reads
Three Life-Changing Events
Paul Randal started a meme about three life changing events that brought him to where he is today. Brent Ozar...
2010-01-18
3,128 reads
What Three Things Brought Me Here
I was tagged
by SQL Rockstar, aka Tom LaRock, after this
thread was started by Paul Randal-not-Paul-Tripp (I wonder if...
2010-01-18
2,064 reads
Should You Achieve All Your Goals?
So many people wrote posts at the end of 2009 analyzing their goals and what they achieved. I did the...
2010-01-18
728 reads
Leaving on a Jet Plane
Ok, so it’s not until November – but I am leaving on a Jet Plane nonetheless. It will have been four...
2010-01-18
571 reads
Notes on the January 2010 oPASS Meeting (Live Meeting)
Before you dig in this post, take a look at my earlier notes about oPASS and Live Meeting and the...
2010-01-18
765 reads
Intel Nehalem-EX and Database Performance
Intel is talking about the upcoming launch of the next generation Intel Xeon processor (Nehalem-EX) being bigger than the Xeon...
2010-01-18
869 reads
Inconvenient – Reading on Paper
I woke up this morning to find Tia reading an actual paper books. That’s become a rarity for both of...
2010-01-17
717 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers