If you are using replication in SQL Server, you can monitor it in SSMS, but it makes sense to monitor distribution jobs automatically, especially if you can set up alerts or even set up first-line remedial action when a problem is detected. Francis shows how to do it in T-SQL as an agent job.
A future world where the machines rule, as shown in films like Terminator and the Matrix, isn't what most people want. However the fears of machines taking over much of our world are very real. Steve Jones thinks it's not as bad as you might believe.
Join us for a free day of SQL Server training and networking in Atlanta on May 18th.
To meet our database configuration standards we want to make sure that we have only one database transaction log file and more than one data file. In this tip we look at how this can be done using a policy.
Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.
With all the talk about Big Data recently, Steve Jones looks at some of the issues with Big Data and how small data might be more important to you.
The easiest ways to maintain and manage slowly changing dimensions is using Slowly Changing Dimension Transformation in the data flow task of SSIS packages.
Research in industry can help a company leap ahead of it's peers. Steve Jones thinks this is a good idea for many companies to engage in and highlights some of the great work being done at Microsoft Research.
The state of cloud computing is confusing and unstable. Steve Jones has a few thoughts about the good and bad things in this industry.
SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they be used? When are they most effective, and what sort of performance gain or space-saving is likely? How does a filtered index affect the choice of execution plan? Seth Delconte explores these questions with practical experiments.
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
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