Mastering SQL Server Profiler - Part 3: Getting Started
This, the third installment of the "Becoming a Profiler Master" online training course, shows how to start, stop and control Profiler and how to save the traces.
Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions
While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries. In this particular case, in the column list of a SELECT statement. Did it make sense to encapsulate a routine...
Script a cube using Windows PowerShell and AMO
This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.
SQL Server Audit: Magic without a Wizard
In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or most highly-regulated industries. SQL Server 2008 Enterprise Edition includes all of the features, whereas SQL Server 2008 Standard Edition only provides a subset. What is most attractive about it, is that it is easy to administer, as Thomas LaRock explains.
Take Care of Yourself
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
Take Care of Yourself
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
Take Care of Yourself
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
A SQL Server Issue? (Database Weekly May 11, 2009)
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part I
Using an audit table to rollback changes to data might be a nice addition to many applications. David McKinney's new series looks at how you can use this data for RollBack or RollForward.
Database Mail and SQL Agent Mail setup by using a script
In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers