2013-02-04
1,474 reads
Articles
Silent Truncation of SQL Server Data Inserts
There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs.
2013-02-01
4,303 reads
Custom Metric - Indexes with Excessive Writes
A new custom metric is available at SQL Monitor Metrics. This tracks indexes that have more writes than reads. Use this code if you want to find out if you might be over indexing your tables.
2013-01-31
2,946 reads
SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell
Marcin Policht presents the fundamental principles of PowerShell in the context of SQL Server 2012. Join him as he steps through its initial setup and configuration, and reviews specific management areas where its advantages can be realized.
2013-01-31
3,203 reads
SQL Server Performance Tuning – Index Tuning
In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning
2013-01-30
5,192 reads
My SQL Server Database is Corrupt - Now What?!
How do you recover from corruption if your organization doesn't have a disaster recovery handbook? And how can you prevent the same corruption from recurring?
2013-01-29
8,751 reads
Providing SQL Agent Job Log Data for Developers
As a production Database Administrator, I do not want to give Developers direct access to the SQL Server Agent job log especially for servers in the DMZ. Another problem we have is that when there is a lot of log data for a job, the default job log doesn't contain the full log detail and that makes it harder to troubleshoot. Most of all, we are trying not to use a different code set for deployment based on the environment. Basically we want to use the same methods to deploy our jobs to Development, Test and Production.
2013-01-29
1,816 reads
Update statistics in parallel
This articles shows a technique that generates and launches an SSIS package to update statistics in parallel.
2013-01-28
5,700 reads
Beating Backup Corruption
The most critical task for all DBAs is to have a Backup and Recovery strategy that ensures, every day, that in the event of a disaster they can restore and recover any database, within acceptable limits for data loss and downtime. Even with all the required backups in place, it's easy to miss subtle failings in the overall plan that can, and eventually will, defeat your recovery plans.
2013-01-28
2,889 reads
Free eBook: SQL Server Backup and Restore
You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.
2013-01-25 (first published: 2012-10-23)
12,771 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers