Finally I am MCSA
I have recently obtained the certification Microsoft Certified Solutions Associate: SQL Server 2012/2014.
I began with this path almost 2 years...
2017-11-20
93 reads
Why shouldn’t I shrink my database data file?
A while back I did a post about why you shouldn’t shrink your data file. This one is going to...
2017-11-20
466 reads
SQL Server – DBCC CHECKTABLE
If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs...
2017-11-20
464 reads
Configure an Azure AD Domain Services
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the need of creating a windows cluster, I had my...
2017-11-20
84 reads
Long Live OLE DB!
Back in August of 2011, an announcement from Microsoft started a wave of angst among those who build and support...
2017-11-20
360 reads
Configure an Azure AD Domain Services
Problem: I was working on getting a demo on how to setup Always On with SQL Server 2017 without the...
2017-11-20
168 reads
SQL Operation Studio Tool
Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!
SQL Operation studio is a lightweight open source...
2017-11-20
1,569 reads
File This Under File Groups (Part 1)
I never had cause to give much consideration to storage when I was a SQL developer. The companies I worked...
2017-11-19
451 reads
Lost in Big Data, perhaps Small Data could help
(2017-Nov-19) I don't remember how I actually found this book "Small Data: The Tiny Clues that Uncover Huge Trends". Most...
2017-11-19
1,298 reads
How to Calculate Running Totals in SQL Server
In show #84 of the SQL Server Radio Hebrew Edition, Matan and I talked about how to calculate running totals in SQL...
2017-12-01 (first published: 2017-11-19)
2,894 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