Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
The Human Touch
Humans are often the weakest links in any computer process, but we do need human input. Steve Jones talks about a few issues, and how we should be changing our workflow to reduce issues.
Disaster Recovery Tip #8: Maintain up-to-date contact information
A corollary to Murphy's Law states that disaster is most likely to strike when your senior people are out of the office.
Intervals and Counts - Part 1
When using SQL Server, you frequently need to work with data that represents intervals of time. For example, consider intervals representing sessions, contracts, projects, and so on. Tasks related to interval manipulation are typically quite intriguing, especially because coming up with efficient solutions isn't easy. Itzik Ben-Gan explains
SQL Saturday #234 Baton Rouge, LA
SQL Saturday is coming to Baton Rouge for a free day of SQL Server training and Networking on August 3.
There is also a pre-conference session presented by Bill Pearson on Practical Self-Service BI with PowerPivot for Excel on August 2nd.
Enable/Disable a table to be read only on the fly
Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?
Flying high on the Big Data hot-air
Today Phil Factor talks about Big Data, and all the hype that's in the news.
Baselining with SQL Server Dynamic Management Views
When you're monitoring SQL Server, it's better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problems becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started.
SQL Saturday #236 St Louis, MO
SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.
Configuring Database Mirroring
This article contains a set of instructions for configuring SQL Server mirroring, including pre-requisites. It also includes notes on how to resolve a few issues that I have encountered.
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...
Finding 'bad' characters
Hi All I am trying to find 'bad' characters that users might type in....
Extreme DAX: Take your Power BI and Fabric analytics skills to the next level
Comments posted to this topic are about the item Extreme DAX: Take your Power...
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