Plays Well With Others – Eight Behaviors of Excellent Leaders
Last week, I talked about one of the worst type of management scenarios to work under – the micromanager. Now, let’s...
SQLServerCentral Webinar Series #4: How to Monitor your SQL Servers
You can monitor your servers with the new SQL Monitor software from Red Gate Software. MVP Brad McGehee showed how the SQLServerCentral servers are being monitored publicly. The slide decks and Q&A transcript at available.
The Need for New Technology
Do we need new technologies to handle the large scales of complex data analysis? Steve Jones thinks SQL Server can handle the load.
Implicit Permissions Due to Ownership Chaining or Scopes in SQL Server
I have audited for permissions on my databases because users seem to be accessing the tables, but I don't see permissions which give them such rights. I've gone through every Windows group that has access to my SQL Server and into the database, but with no success. How are the users accessing these tables?
SQL Server 2008 R2 Best Practices Analyzer
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
Changing Jobs
Today Steve Jones talks about the reasons why you might change jobs, and the fact that you aren't alone. However be careful about changing jobs, and make an attempt to stay if you can.
Script Task Exception Handling in SSIS
When working with Script Task of SQL Server 2008 Integration Services, it is important to ensure that your custom code complies with the most elementary programming practices. Learn how to handle unexpected errors that interfere with the successful execution of your code.
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
Help with Performance
Performance is always one of the most important things a DBA can learn to deal with. It's also one of the more nebulous arts to learn. Today Steve Jones shares some thoughts on how we might better help people learn.
SQLServerCentral Webinar Series #5: Setup Your Source Control With Help from PowerShell
MVP Allen White shows how he can use Powershell to setup SQL Source Control from Red Gate Software on Nov 18, 2010.
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers