SQL Saturday returns to Redmond, WA
SQL Saturday returns to Redmond, WA, Saturday, June 12, 2010, in the Microsoft Commons.
I have submitted 2 proposals for presentations,...
2010-02-17
751 reads
SQL Server Soldier :: News from the frontlines of the database wars
SQLSaturday 26 Session Files
SQLSaturday 26 Sessions: 10/3 in Redmond, WA
Thanks to everyone that attended my sessions at SQLSaturday 26 in Redmond, WA on...
2009-10-04
1,042 reads
Database Mirroring FAQ: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?
Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?
This question was...
2009-05-13
1,665 reads
Suggested Reading: Microsoft SQL Server 2008 Administration with Windows PowerShell
Suggested Reading: Microsoft SQL Server 2008 Administration with Windows PowerShell
My earliest forays into writing powershell for SQL Server found me...
2009-04-30
2,266 reads
Behind Every Great Restore is a Great Backup
Behind Every Great Restore is a Great Backup
I showed you how to do a database backup with powershell a few...
2009-04-22
2,519 reads
I Need a Backup and I Need It Now
I Need a Backup ... And I Need It Now
Have you ever wished that creating a backup on the fly was...
2009-04-18
3,512 reads
What's my (fully qualified domain) name?
What's my name?
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring...
2009-04-11
9,490 reads
My Kingdom for a Port
A Port, a Port! My Kingdom for a Port!!
One of the steps in setting up database mirroring is to assign...
2009-04-09
1,078 reads
Coming Soon: Pro SQL Server 2008 Mirroring
Coming Soon: Pro SQL Server 2008 Mirroring
Pro SQL Server 2008 Mirroring will be the first book dedicated to the subject...
2009-03-29
2,115 reads
Do You Support the Ancient Ones?
Do You Support the Ancient Ones?
Are you still supporting SQL Server 2000? How about 7.0 or 6.5?
Officially, Microsoft support has...
2009-03-29
2,235 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Alamat BCA KCP Bontang Kontak 0817819444
WhatsApp:0817819444 Ruko Bontang Trade Center, Jl. Bhayangkara A10-A11, Gn. Elai, Kec. Bontang Utara, Kota...
Alamat BCA KCP Sangatta Kontak 0817819444
Jl. Yos Sudarso, Sangatta Utara, Kec. Sangatta Utara, Kabupaten Kutai Timur, Kalimantan Timur 75611
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers