Troubleshooting CPU Performance on VMware
Jonathan Kehayias discusses SQL Server on VMware, and how to monitor CPU performance – with or without access to vCenter.
2017-07-07
5,127 reads
Additional Articles
How to Generate a Restore Script
There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?
2017-07-06
3,891 reads
The Basics of Good T-SQL Coding Style
TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and plan to never change job, then you need to comment and document your code, it must be inherently readable, well laid out, use informative and obvious names, and it must be robust and resilient; written defensively. It must not rely on deprecated features of SQL Server, or assume particular database settings. Robert Sheldon starts a series of articles that explains the basics.
2017-07-05
7,732 reads
3 Solutions For Auditing Long SQL Server Extracts or Loads
In this post, Tim Smith looks at the different options you can use to audit your SQL Server extracts and loads during the ETL process.
2017-07-04
3,755 reads
Export data from SQL Server to Excel
What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.
2017-06-30
5,930 reads
Azure Automation Methods
Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.
2017-06-29
3,697 reads
Generating HTML from SQL Server Queries
You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.
2017-06-28
5,489 reads
How to Read the Transaction Log File
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
2017-06-27
4,882 reads
A DLM Approach to Database Testing
Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release.
2017-06-26
3,875 reads
Getting Started with Azure SQL Data Warehouse - Part 5
In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali looks at performance optimization.
2017-06-23
3,202 reads
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
Postgresql Replication Issue:
[enterprisedb@DR-PG-SRV ~]$ pg_basebackup -h 192.168.1.43 -p 5444 -D /pgfs/dbcluster/area13mas/ -U replicator -v -P -X...
statistics callection intervel in query store ?
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
Rounding Off issue in SQL Server
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers