This editorial was originally published on October 20, 2005. It is being reprinted as Steve is on vacation. I know there was a great uproar over the interview piece at the beginning of this week and I received lots of opinions on various parts of the article, good and bad to go over. But one […]
Learn the basics of first normal form and what that means to a database designer from Tom Thomson.
I have seen several tips on SQL Server Central Management Server and I want to implement the technology for my team. The only thing holding me back is security. Can you explain how security works with Central Management Server? What security access is needed to manage CMS? How about connecting to CMS? How about running a query using CMS? Check out this tip to answer these questions.
Today we have a guest editorial from Andy Warren. We have regular maintenance that needs to be performed on our cars, and also regular maintenance that needs to be done on our servers. Andy points out that companies need to understand this and make sure these regular activities are performed.
I want to determine who the local administrators are on each of my SQL Servers. Basically, I'd like a nightly job to run against each of my SQL Servers and produce a list of admins for each server for my review. How can I do this?
In the second part of his optimization series, Dave Ballantyne shows us how to add conditional logic to set based, more efficient T-SQL code.
We all know how important tempdb is and know that tempdb gets recreated every time SQL Server is restarted. Here we dig a little deeper to focus on how space is used inside tempdb.
The cloud should bring with it lower costs, and better efficiency, but that's not necessarily the way things are. Microsoft has a great internal project that costs out the cloud for their departments, and this would be a great addition to the public or private clouds.
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers