The PASS Board of Directors Election
There has been some great discussion about the upcoming PASS Board of Directors election over on Brent Ozar’s blog. If...
2009-10-15
1,257 reads
Blog Posts
120 DBAs and Developers Attend SQL Down Under
The fourth annual SQL Down Under Code Camp was held at Charles Sturt University in Wagga Wagga, Australia this past...
2009-10-14
381 reads
Dev Days – Austin
I’m out of the office today, in Austin, TX (yee-haw!) at the Stack Overflow Dev Days – Austin. There are a...
2009-10-14
760 reads
DRP for SQL Server in French - traduction en français du plan de relève – part 4
La liste des fichiers restaurés devrait se trouver dans le répertoire suivant :
\\ServeurDeBD\Disque$\DirSauvegardesProd\DBlog\
Dès que la restauration a été complétée, nous...
2009-10-14
813 reads
Free T-SQL Database Maintenance Scripts
I often get questions in e-mails, or at user group meetings, for advice on writing T-SQL database maintenance scripts. There...
2009-10-14
4,307 reads
Live Writer Plugin for Amazon
Among the things I’m experimenting with this quarter is changing my book reviews to include an affiliate link to Amazon....
2009-10-14
311 reads
Network backup Access via Query Analyzer
Hi,
Today while working on query analyzer found very interesting thing about security.
My sql server A is running with service account...
2009-10-14
611 reads
PASS Election Voting Has Started
You should get an email if you’re eligible to vote with a subject line beginning with ‘Vote for the 2010/2011...
2009-10-14
283 reads
SQL Lunch Recap
Earlier this week, I delivered a presentation entitled “Deploying Report Builder 2.0 for Self-Service Reporting” as part of the new...
2009-10-14
661 reads
SQL Server Central Guest Editorial
My second guest editorial is up at SQL Server Central. These are fun to do (especially the video) even though they’re...
2009-10-14
555 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers