PaaS and the ever changing role of the DBA
I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list...
2017-12-26 (first published: 2017-12-12)
1,663 reads
Microsoft to Decommission Connect on 12/31/2017
Microsoft will be decommissioning the Connect platform on 12/31/2017 due to privacy concerns and will be replacing it with a...
2017-12-11
448 reads
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”)
(If you’re reading this on SQL Server Central, please click here to see the “Featured Image” which will help explain...
2017-12-28 (first published: 2017-12-11)
1,829 reads
New Course: Implementing a Hybrid Cloud Solution in Azure
My latest Pluralsight course – SQL Server: Implementing a Hybrid Cloud Solution in Azure – is well over two hours and long and is based...
2017-12-11
611 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, graciously...
2017-12-11
13 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, graciously...
2017-12-11
12 reads
An Open Letter to the SQL Community: Requests of Speakers
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices,...
2017-12-11
445 reads
Renaming a Column–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-12-27 (first published: 2017-12-11)
2,023 reads
Learning to Give Presentations Well (Part 3)
See Part 1 and Part 2.
Perfect Practice Makes Perfect
I can remember my Air Force ROTC class on communications skills where...
2017-12-29 (first published: 2017-12-11)
1,433 reads
Execution Plan Metrics and Units of Measure
Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...
2017-12-26 (first published: 2017-12-11)
1,444 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