SQLBits XI - My second most eagerly awaited event of 2013...
I bet you are half wondering what is the first? Well that would be the birth of my second child...
2013-01-17
796 reads
Does the SQL Server Database Filename Matter?
Do you know the basics of how to create a database? Hopefully you do and can do so without the...
2013-01-17
2,803 reads
Leverage Policy Based Management for regular Page Verify =Checksum compliance monitoring
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new...
2013-01-17
1,046 reads
SQL Server 2012 SP1 Causes MsiInstaller Application Log Entries
After installing SP1 to SQL Server 2012 (11.0.3000) on one of our servers, I noticed higher than normal CPU loads due to...
2013-01-17
1,242 reads
New Years Aspirations – James Rowland-Jones – PASS
Thanks for agreeing to do this James; I know as you run your own company your time is billable!
Before we...
2013-01-17
1,537 reads
STATS_DATE() Doesn’t Indicate The Validity of Statistics
From time to time, you might have caught yourself in a conversation similar to the following:
Fred: Hey folks, we have...
2013-01-17
1,277 reads
The right terminology for the right audience
For those who has the privilege of being in the technology consulting industry for some time and started out in...
2013-01-17
397 reads
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of a database. You can read that story here. This...
2013-01-17
8 reads
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of...
2013-01-17
1,242 reads
Cash Over Credit
What does cash over credit have to deal with security? An awful lot, as it turns out.
Personal Story: Mere days...
2013-01-17
1,223 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