Actual Emails: Allow NUNS to Lead You to Good Clustered Index Design
Wrote this email exchange with a colleague who wanted to confirm that the client-proposed design for a table was... less...
2015-08-23
439 reads
Blog Posts
WWH in SSIS ? Zero to Hero in SSIS series TIP#111
Dear Friends,
As shared in last post Post #110, We are starting SSIS tutorialseries ( A Step by Step SSIS learning tutorial)...
2015-08-22
822 reads
016 – Me, Myself and I - WaterOx Consulting
Me, Myself and I In WOxPod!, episode # 016 – “Me, Myself...
The post 016 – Me, Myself and I appeared first on WaterOx...
2015-08-21
803 reads
Designing a Data Warehouse from the Ground Up Webinar Recording with Q & A
Thank you to everyone that registered and attended my webinar Designing your Data Warehouse from the Ground Up webinar this...
2015-08-21
750 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-21 (first published: 2015-08-17)
1,962 reads
Using Power Bi with my DBA Database
Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
I...
2015-08-21 (first published: 2015-08-16)
4,339 reads
Versions (Master Data Services) - Where to use
Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS)...
2015-08-21
257 reads
Versions (Master Data Services) - Where to use
Multiple versions of the master data within a model can be created in Master Data Services(MDS).When you create a model...
2015-08-21
702 reads
Changing Cell Phones Again
Slightly off topic, but since I use a cell phone so much for data transfer and work, it’s important that...
2015-08-20
840 reads
How to manage SQL Server security with SQL Source Control
One of the most common issue you can find when source controlling the database is about the security. How to manage...
2015-08-20 (first published: 2015-08-15)
2,189 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