Too Much Data
Are you managing too much data? Lots of data professionals feel that way, but fortunately "Big Data" is in the news and bringing more visibility to the challenges we face on a daily basis.
2012-11-13
175 reads
Editorial
The Data We Give Away
We're all used to storing and protecting data, but how often to we consider the data we're generating every day?
2012-11-12
70 reads
Monitoring is Essential
One of the keys to better availability, scalability, and performance on your systems is understanding what is happening in the instances. That requires monitoring, which Steve Jones sees as essential.
2012-11-12
275 reads
What Do You Want from SQL in the City?
After the SQL in the City tour wrapped up this week in Seattle, Steve Jones looks back and asks a question. What type of training would be best for you.
2012-11-09
130 reads
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2012-11-08
202 reads
2012-11-01
108 reads
DBA Support
This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.
2016-10-07 (first published: 2012-10-26)
241 reads
Two Steps Ahead
Today Steve Jones talks about those great DBAs, the Exceptional ones that do more than just respond to issues or set up monitoring on their systems.
2012-10-25
161 reads
A SQL Server Log Reader
There's a hole in the SQL Server platform. No log reader comes with the product and Steve Jones thinks Microsoft should build one and include it.
2012-10-24
407 reads
Walk on the Wild Side
Today Steve Jones talks about the differences between development and production and how it can be good to spend a little doing the other type of work.
2012-10-23
112 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers