A really simple Multiprocessing Python Example
Purpose and introduction A Python program will not be able to take advantage of more than one core or more...
2012-12-21
4,762 reads
PASS SQLRally Nordic 2012 videos online
All the videos for the sessions at PASS SQLRally Nordic 2012 are available for free. Lot’s of great BI info. Check...
2012-12-20
896 reads
On the Eighth Day…
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll explain about that later in this post. This should...
2012-12-20
10 reads
On the Eighth Day…
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll...
2012-12-20
1,563 reads
Building a Full Text Index
I hadn’t used full-text indexing in production throughout my career. We hadn’t had the need in the applications I worked...
2012-12-31 (first published: 2012-12-19)
3,926 reads
Active Directory Group Membership and Powershell
I’ve done my fair share of work with Active Directory over the years and LDAP has helped immensely, it did...
2012-12-19
841 reads
SQL Server – Skipping Function Execution when parameters are NULL
You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create...
2012-12-28 (first published: 2012-12-19)
4,131 reads
Red errors in the results pane
Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed...
2012-12-27 (first published: 2012-12-19)
2,104 reads
On the Seventh Day…
So far this series has been a bit of fun. We have discussed a fair amount of useful things to date. And here we are only on the seventh...
2012-12-19
10 reads
On the Seventh Day…
So far this series has been a bit of fun. We have discussed a fair amount of useful things to...
2012-12-19
1,433 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers