April Hammond .net User Group Presentation - SQL Server Security and Permissions
Here's the slide deck and sample files from last night's presentation at the Hammond .net User Group. We discussed SQL...
2012-04-26
977 reads
SQL Server 2012 Diagnostic Information Queries (April 2012)
It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...
2012-04-26
2,705 reads
The Mentoring Experiment – Cycle 2
It’s been a long time, almost a year since Andy Warren and I kicked off The Mentoring Experiment. We had...
2012-04-26
932 reads
AlwaysOn Failover Bug
I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a...
2012-04-26
1,250 reads
See you at SQL Saturday 130 Jacksonville!
http://www.flickr.com/photos/rohicks/4788477593/
Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL! The good people from the Jacksonville...
2012-04-26
901 reads
Beer, Cheese and SQL Saturday 118 Madison
This past weekend I (w|t) headed up to Madison, WI to attend and present at SQL Saturday 118. The MADPASS...
2012-04-26
991 reads
Offset without OFFSET
A while ago Robert Cary posted an article on SQL Server Central entitled 2005 Paging – The Holy Grail which is,...
2012-04-26
2,034 reads
Enterprise Data Warehouse Architecture Options
Enterprise Data Warehouse Architecture Options
Of course, your architecture depends on your business requirements along with technical, historical, and political factors....
2012-04-25
4,280 reads
Creating a Symmetric Key in SQL Server
Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and...
2012-04-25
12,531 reads
2012 (2011) Data Breach Report
I had a chance over the weekend to finish reading the Verizon 2012 Data Breach Investigations Report. It’s a compilation...
2012-04-25
1,109 reads
Blogs
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....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers