SQL Server Quickie #3 – Allocation Units
Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I’m talking about Allocation Units in...
2012-09-18
609 reads
Blog Posts
SQL Server Quickie #3 – Allocation Units
Today
I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking
about Allocation Units in SQL Server....
2012-09-18
1,586 reads
SQL Server: Part 1 : Approaching Database Server Performance Issues
When you work as DBA, many people will approach you with a complaint like "Application is taking ages to load...
2012-09-18
1,410 reads
A Job Done Quietly and Well
My current client has a five story building, two break rooms and two sets of bathroom per floor, with I’m...
2012-09-17
626 reads
An Introduction to SQL Server
I will be delivering Learning Tree course 137 SQL Server 2008 a Comprehensive Hands-On Introduction in London this December (18th...
2012-09-17
747 reads
How to Connect PerfMon to a Remote Server ?
Till now, we do not have any third party tool to monitor the SQL server, but we have implemented many custom...
2012-09-17
4,968 reads
How to log SQL Server Custom Error in Windows Event Log ?
SQL server gives an option to log custom errors in windows event log. We have 2 options of achieving this.
Option...
2012-09-17
961 reads
Logon Triggers: SQL Server
As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...
2012-09-17
24,343 reads
Running a SQL Server Environment at Home Using Native Boot Virtual Hard-Drives (VHD)
I’ve run into a road block. As a Microsoft Certified Trainer, I have all the software I need to get...
2012-09-17
1,173 reads
SQL Saturday 154 Rocked - Great Job St. Louis!
This last Saturday (09/15/2012) I traveled to St. Louis to present at #sqlsat154. My colleague David Klee (blog/@kleegeek) and I...
2012-09-17
892 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers