SQL Slammer
It's been seven years since SQL Slammer, the worst SQL Server security worm struck. Steve Jones remembers that time.
SQLServerCentral Webinar Series #3: Optimize your SQL Server storage with SQL Storage Compress
Another webinar from SQLServerCentral that examines how you can compress your data on any edition of SQL Server.
Introducing ADO.NET Entity Framework
The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applications and the database. This requires an understanding of the database so that you can access data either from the raw tables, from views, or from stored procedures.
Sending multiple rows to the Database from an Application: Part II
In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.
Investigating Transactions Using Dynamic Management Objects
There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When you hit performance problems in a database under load, and there is excessive locking and blocking, how can you determine exactly where the problems lie, in order to fix them?
Cheap Fun
Today we have a guest editorial from Andy Warren that talks about ways to enjoy life without spending a lot of money. Some of these might even be great team building ideas.
Notifications for SQL Server Agent Restarts
This article demostrates how to set up email notifications for SQL Server Agent Restarts.
When was SQL Server Restarted?
While doing some performance testing recently and utilizing some of the DMV’s I figured, I better find out when the...
Mid October Free Training from PASS Virtual Chapters
More free training this month from PASS B/I, PowerShell, and Oracle Virtual Chapters.
Plan for Capacity
It is important that you are monitoring your system to handle the capacity increases as it grows. Steve Jones notes that FourSquare recently had to deal with this.
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