Notes from the February Space Coast SQL Meeting
I drove over to Melbourne last night to the new home of Space Coast SQL at the Harris Institute for...
2012-02-10
725 reads
Blog Posts
Powershell default start directory
This post discusses some methods in configuring the Powershell default start directory
By default , the installation process will add a value...
2012-02-10
1,795 reads
Review: I Done This
IDoneThis is a simple web site for tracking accomplishments. The premise is that you get a checkbox on the calendar...
2012-02-10
816 reads
Slides and Scripts from Idera February webcast
For those who've asked, here are the slides and scripts from my SQL Server auditing webinar with Idera:
Presentation (.PDF)Scripts (.ZIP)
If...
2012-02-10
1,034 reads
Speaking At SQL Saturday #110 in Tampa
I got word this week that one of my sessions for the upcoming SQL Saturday #110 in Tampa, FL was...
2012-02-10
428 reads
SQL Azure
SQL Azure is a cloud-based service from Microsoft that uses a special version of SQL Server as its backend. SQL Azure...
2012-02-10
2,426 reads
Thanks to Brian Kelly for a Great Presentation on Auditing for SQL Server - Please Find the Notes Below
For those interested in following a great MVP who contributes regularly on Infrastructure and Security, here are notes I took...
2012-02-10
1,029 reads
A Script A Day - Day 9 - Index Compression Estimations
Today's script provides amongst other information Index compression estimates based on existing index information. All you need to do is...
2012-02-09
1,306 reads
An open letter to anyone with “SQL Server” on their resume
Dear Sir or Madam,
I have your resume here in my hand and couldn’t help but notice that you have listed...
2012-02-09
2,897 reads
Data Page math : 96 + 8060 + 36 = 8192. is this correct?
I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum...
2012-02-09
1,694 reads
Blogs
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Forums
database restore chain
I have a backup of full, differential and transaction log setup for our database....
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
A Few Good DBAs
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers