The SSMS maintenance plan wizard is shunned by many DBAs, but Brad McGehee has come to view it as a perfectly valid and viable tool, especially for part-time or accidental DBAs, or those just finding their feet in the role.
A list of books to read in any area from an expert can be invaluable in growing your skills. Steve Jones talks about one list from Paul Randal, former SQL Server developer.
A list of books to read in any area from an expert can be invaluable in growing your skills. Steve Jones talks about one list from Paul Randal, former SQL Server developer.
A list of books to read in any area from an expert can be invaluable in growing your skills. Steve Jones talks about one list from Paul Randal, former SQL Server developer.
A list of books to read in any area from an expert can be invaluable in growing your skills. Steve Jones talks about one list from Paul Randal, former SQL Server developer.
Almost halfway into the first month of the new year, Steve Jones reminds us of the power of goals. Today he encourages you to set up your own goals for the coming year.
Almost halfway into the first month of the new year, Steve Jones reminds us of the power of goals. Today he encourages you to set up your own goals for the coming year.
This one caught my eye on the Data Mining Forum and it is not the first time that this one...
Every now and then, I see someone doing repetitive tasks in SQL Server Management Studio such as dropping a stored procedure one by one when they need to remove ten or scripting out a single object at a time because they can't select multiple objects from the Object Explorer. I have even seen people create elaborate scripts to perform tasks that involved manipulating multiple database objects to avoid these mundane tasks. In this tip I will show you how this can be done simply by using SQL Server Management Studio.
Here is a challenge that takes you away from those repetitive boring type of queries that you write over and over again, several times a day. All of us, the database people, are familiar with thinking in set based manner as well as row by row style. Here is something that is very interesting where you might need to process records in a 'three-line-at-a-time' fashion.
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
Hi, below i show various results trying to reach our ftp site (a globalscape...
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers