Limited Features or Limited Time?
A guest editorial today from Andy Warren. When someone is looking to introduce a free version of a product, what's the best way to tackle it?
Using SQL Profiler to Resolve Deadlocks in SQL Server
MVP Jonathan Kehayias brings us a short article on how to troubleshoot deadlocks in SQL Server.
Tables and Views for Auditing SQL Server Logins
I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?
Change the Edition or Change the Design?
Today Steve Jones talks about revisiting your design and perhaps thinking about buying another edition of SQL Server to take advantage of some feature.
SQL Saturday #43 - Redmond
If you are in the Redmond, WA area, join in for a free day of SQL Server training on June 12, 2010.
Reliable Storage Systems for SQL Server
By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage
Loud
Working in an office was quite a change for Steve Jones recently. He comments today that it might be something you need to consider when hiring others as well.
TDE, EKM and the Asymmetric Key
A look at how you might recover from a disaster using encryption and an HSM module in SQL Server 2008.
Built-In SQL Server Agent Performance Reports in SQL Server 2005
SQL Server 2005 includes a number of built-in reports to assist you in troubleshooting and measuring performance. In this tip I will cover the Built in SQL Server Performance Reports related to SQL Server Agent within SQL Server 2005.
Kalen Delaney at the Denver SQL Users Group
Sponsored by Dell, Kalen Delaney is coming to the Denver Marriot Tech Center on June 9.
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers