Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
Auto alert for SQL Agent jobs when they are enabled or disabled
It is often the case in large DBA teams where multiple DBAs can administer the same SQL Servers and it is not apparent to one DBA the importance of some of the jobs to another DBA. In this tip I show how you can be alerted of these changes.
Sin City SQL
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
Sin City SQL
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
Sin City SQL
Join Steve Jones and a few of the SQLServerCentral community in Las Vegas this fall at the SQL Connections conference.
Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS
The Transfer SQL Server Objects Tasks is a very useful tool in SQL Server 2005 to move objects between SQL Server Instances.
BNF Basics
Learn about the basics of Backus–Naur Form. If you've never heard of this, Tom Fischer explores this way of structuring technical information.
Networking for Your Career
It's hard to actually put a specific value on networking, and I've been skeptical of it in the past. However...
Q&A: The skinny on Reporting Services 2008
Get the inside scoop on SSRS 2008 with Michael Lisin and Jim Joseph, co-authors of the new book, "Microsoft SQL Server 2008 Reporting Services Unleashed."
Slicing and Dicing
There can be a lot more value when pieces of data are put together than when they exist separately. Steve Jones comments on a few ways people are repackaging information in the modern world.
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Solutions for Environmental and Pollution Testing | Fare Labs Pvt. Ltd.
The state-of-the-art FARE Labs Environmental Testing Laboratory provides a broad range of testing services...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers