SQL Server Storage best practices
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,473 reads
Blog Posts
Why I won’t be running SQL Server Standard Edition on Business Critical Servers!
I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a...
2015-07-09
1,158 reads
Database Settings Changes – Red Handed
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed) without knowing about it. Worse yet is finding that...
2015-07-08
17 reads
Database Settings Changes – Red Handed
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed)...
2015-07-08
636 reads
Get a comma separated list
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-07-08
3,871 reads
Hello world!
Hi there!
Although this looks like my first blog post, it actually isn’t. This is the new place for my blog,...
2015-07-08
380 reads
How to Grant limited permissions to create views in another schema?
How to Grant limited permissions to create views in another schema?
In SQL Server 2005 and 2008R2 you can grant permissions...
2015-07-08 (first published: 2015-07-01)
3,265 reads
Integrating Other Data Mining Tools with SQL Server, Part 2.2: Minitab vs. SSDM and Reporting Services
By Steve Bolton
…………Professional statistical software like Minitab can fill some important gaps in SQL Server’s functionality, as I addressed in...
2015-07-08
1,789 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net) products to start an instance of SQL Server without...
2015-07-08
11 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
42 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
Alamat Kantor BCA KCU Galaxy Tlp:(08218154374)
WA CS 628218154374 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya,...
Alamat Kantor BCA KCU Malang Tlp:(08217555651)
WA CS 628217555651 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa...
Alamat Kantor BCA KCU Rungkut Tlp:(0817825533)
WA CS 628217825533 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers