Economics
Today we have an editorial from Mar 22, 2006 as Steve is on vacation. Today Steve Jones notes that economics might determine how you are paid, but human nature describes how you behave.
Raw Materials - Childish Games
Digitization transforms yet another of our most cherished traditions.
Why System Account is a bad idea for SQL Server Service Account
I'm trying to set up SQL Server and I know that I'm not supposed to use an account that's an administrator on the system, as per best practices. I see that the System account is a possibility, but I've been advised not to use it. Why not? Check out this tip to learn more.
Ethics
Today we have an editorial reprinted from April 3, 2006 as Steve is on vacation. Ethics are often just as bad at the top of our companies as they are at the bottom. Steve Jones comments today on how this affects IT.
Lessons Learned Pay Off
This week Steve Jones looks at a few notes that show employers are wising up overall about certifications and the value of real world skills.
SQLServerCentral Best Practices Clinic: Part 4
In this next installment looking at implementing best practices here at SQLServerCentral, Brad McGehee looks at a few performance counters and what they tell us about the performance of our database server.
Using SQL Server to collect information from your Oracle server
Using linked connections you can collect system information on your Oracle server from SQL server.
Using PowerShell to Manage SQL Server
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs. I will call this framework comprised of a library of modules and functions specialized to manage SQLServer the DBA profile.
A Live Node
Today we have an editorial from March 29, 006 as Steve is on vacation. Today Steve talks about the problems of constantly being distracted and not focusing on one thing.
Advice from Exceptional DBAs: Do it!
Nominations for the Exceptional DBA of 2011 opened on May 25. Bob Cramblitt spoke with past award winners to find out what has happened to them since receiving the award and to get advice for people thinking about nominating themselves or colleagues.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers