I’m Going on Tour
I’ve done quite a bit of speaking over the last few years, which has required a lot of travel. I...
2012-06-01 (first published: 2012-05-30)
2,271 reads
Blog Posts
June Question: Which DMV(s) do you most often use when managing your SQL Server instances, and why?
Dynamic Management Objects (DMVs and DMFs) are some of the most useful tools for the DBA. So this month’s question...
2012-06-01
1,039 reads
Ottawa In the Summer Time
I wrote a post earlier this week telling you all about my trip to Ottawa last week, during my trip...
2012-06-01
873 reads
Setup windows firewall for SQL Server
On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...
2012-06-01
5,411 reads
SQL Server 2008 Security Best Practices
If you are working as a DBA for a financial organisation where sensitive financial data is stored in your databases...
2012-06-01
13,327 reads
The SQL in the City US Tour
If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...
2012-06-01 (first published: 2012-05-29)
1,791 reads
The Standing Desk – Week 1
I finally got my standing desk working last weekend and started on Tuesday (after Memorial Day) working at it on...
2012-06-01
1,120 reads
A new neat feature in SQL Server 2012 is THROW
In SQL Server 2005 we got the TRY…CATCH construct which was a big help for developers to effectively handle errors...
2012-05-31
3,342 reads
After August, I'm Done Traveling for the Year
I mentioned in a post over at my Goal Keeping DBA blog that I was not planning to attend the...
2012-05-31
2,112 reads
Building a SQL Server Inventory – Part 1
Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with...
2012-05-31 (first published: 2012-05-29)
5,943 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