Automating Daily Checks with Powershell
Using Powershell to create color coded backup reports for all servers in your environment.
The Connections Launch Event
SQLServerCentral will be hosting a track at the 2012 spring SQL Server Connections conference and we hope to see you there.
Virtualization and the existential angst of the DBA
Tony Davis reflects on the existential angst felt by the DBA separated from his or her hardware.
Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting
DBAs are usually charged with the administration of Reporting Services, but are often short on guidance on how to go about such tasks as planning, documenting and troubleshooting those aspects that are specific to the SSRS service. Feodor Georgiev gives some tips, custom SSMS reports, and useful TSQL queries, based on his experience.
People That Get It Done
Today we have a guest editorial from Andy Warren. This one follows on from his "are you easy to work with" piece.
Why SHRINKFILE is a very bad thing, and what to do about it.
This article talks about why SHRINKFILE is a very bad thing, and what to do about it if you must shrink a database file.
Building Ranges using T-SQL
We often use excel for any running repetitive calculations since it is a very convenient user friendly interface which allows us to just enter a formula in a cell and simply drag and drop the formulas to generate a complete output.
Careful with your Smartphone
Do you connect to your work network with your smartphone? If so, you should be careful and ensure you are taking precautions to prevent any security issues.
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers