SQL 2000 TIPS AND TRICKS DECK AND DEMOS
Hello Dear Reader today I'm going to be presenting on SQL 2000 Upgrade tips and tricks for Pragmatic Works Training...
2012-06-28
1,195 reads
Blog Posts
Troubleshooting Database Mirroring Error 1418 Updated
Troubleshooting Database Mirroring Error 1418 Updated
Last night I was helping someone with a database mirroring setup problem via email. It...
2012-06-28
3,832 reads
Guest Post – DBAvolution
One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it...
2012-06-27
2,008 reads
How Local Variable or Optimize for Unknown Resolve Parameter Sniffing
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible...
2012-06-27
3,427 reads
How to Create Reporting Services 2012 Report Templates
When I started writing this blog I realized it has been several months since my last post. I guess that...
2012-06-27
9,449 reads
How to Create Reporting Services 2012 Report Templates
When I started writing this blog I realized it has been several months since my last post. I guess that...
2012-06-27
1,728 reads
Last Week to Enter the Exceptional DBA Contest
Just a reminder: you have until this Friday to enter the 2012 Exceptional DBA awards. I’m judging, and looking forward...
2012-06-27
1,621 reads
Microsoft Data Quality Services in SQL Server 2012
SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012. The...
2012-06-27
5,187 reads
Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"
You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" .
First, in BOL, for "DBCC...
2012-06-27 (first published: 2012-06-23)
17,948 reads
Super SQLSaturday #158 Summer Spectacular Event Update & Speaker Schedule!
When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent...
2012-06-27 (first published: 2012-06-24)
2,244 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers