SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server
A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local...
2017-08-08
3,510 reads
Interview Patterns and Anti-Patterns Combined
It’s that time again. T-SQL Tuesday. The monthly blog party started by Adam Machanic (b/t) seven and a half years...
2017-08-08
388 reads
T-SQL Tuesday #93–Interviewing Patterns
It’s time for T-SQL Tuesday, and this is a good topic. Not too close to T-SQL, but certainly something many...
2017-08-08
450 reads
Learn How to Recover Deleted Records from SQL Server 2014
Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a...
2017-08-08
15 reads
Learn How to Recover Deleted Records from SQL Server 2014
Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their...
2017-08-08
5,233 reads
SQL Server vs Oracle: End of Month
Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from...
2017-08-08
305 reads
Presentation Nerves
My previous post on interviews and a number of conversations this year inspired me to write this post. I am...
2017-08-08
447 reads
Training and tips to get certified with Microsoft (Part 2)
In my previous post I answer the first of the regular questions I usually get in regards of the MCSA certification,...
2017-08-08
274 reads
Capturing Perfmon Counters With Telegraf
InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...
2017-08-08
796 reads
Data modeling in Power BI using XML file with Parent and Children nodes
[2017-Aug-08] Support for XML structured files as a data source has been available in Excel, then was introduced into the Power...
2017-08-08
12,778 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