Test Your SQL Memory Setting with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-10-02
439 reads
SQL Homework – October 2017 – Sample/Test Database(s)
Last month your homework was to set up your own lab. Now it’s time to put a sample database or...
2017-10-02
434 reads
SQL Server – Pause VS Stop
You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...
2017-10-02
370 reads
Monday Coffee: Long hours worked
Last week I asked the following question on twitter: –
I had a load of responses from a lot of DBAs...
2017-10-02
286 reads
Want to know what software is running on the VSTS Hosted Agent? Go here….
This is related to my previous post about installing things on my Private-Hosted agent that I use for my VSTS...
2017-10-02
278 reads
New Pluralsight Course – LFCE: Linux Service Management – HTTP Services
My new course “LFCE: Linux Service Management – HTTP Services” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to...
2017-10-01
29 reads
New Pluralsight Course – LFCE: Linux Service Management – HTTP Services
My new course “LFCE: Linux Service Management – HTTP Services” in now available on Pluralsight here! If you want to learn about the course,...
2017-10-01
515 reads
When upgrading a Visual Studio project — you need to upgrade your TFS/VSTS Agent
This post is linked to my post about hosting VSTS private agents . I had recently upgraded my Visual Studio environment...
2017-10-01
501 reads
Welcome to The Monday Morning DBA
I started my IT career twenty years ago as a VB and C developer, wandered into C++ for a bit,...
2017-09-30
356 reads
SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing
“Trusted Assemblies”, a new feature starting in SQL Server 2017, is a means of whitelisting Assemblies that one feels pose...
2017-10-09 (first published: 2017-09-29)
2,327 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