As a DBA, we often need a way to track what events are occurring (changes that are being made) on SQL Server or at the database level. So what is a way to track these changes without much impact on SQL Server performance?
Another weekend, another new city, another SQL Saturday. This was my first trip to Kansas City, and it was a...
Today we have a guest editorial from MVP Jessica Moss that talks about the gender differences in the workplace, and how you can work to get beyond them.
In this article Mohammad Meimandi explains an issue faced while using SQL-DMO to copy database objects.
Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is...
Today we have a guest editorial from Jen McCown, one half of the Midnight DBAs. Jen wonders why we are still talking about women in technology? Women do the same jobs as men in this field.
A new series from David Ziffer describes a way of building applications in a more standardized fashion, and it provides a basic review of some software that can help.
The following production code is what I used for inserting and updating database tables using XML as the input. These scripts are for processing data for any table to insert or update data. The support functions provided, retrieve the table schema with their data types, functions to deal with XML dates, primary keys of the table and what fields can be updated. The following article breaks down this process from beginning to end.
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
My wife apparently ask her phone a question and below is what she sent...
Comments posted to this topic are about the item I Love Editorials
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers