Jump start your SQL 2012 Certification for FREE
Hey all you proactive SQL junkies, want to jump start your SQL 2012 Certification? Or are you just here because...
2012-08-06
453 reads
Blog Posts
Learn to Use Books Online
One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...
2012-08-06
2,168 reads
Recovering from out-of-disk space conditions for tempdb
Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...
2012-08-06
3,248 reads
Rollback TRUNCATE TABLE statement
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,434 reads
SQL Audit 201 – Creating an Audit Solution
Welcome back, folks!
Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s...
2012-08-06 (first published: 2012-07-31)
6,721 reads
SQL Server - Oracle Architectural comparison
This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...
2012-08-06
4,612 reads
SQL Server : Lost all Administrator Account in SQL Server and Forgot sa Account Password
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
7,990 reads
SQL Server: How Recursive Common Table Expression (CTE) Works ?
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,281 reads
The first record on data page.
TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...
2012-08-06
1,198 reads
Time Flies When You're Having Fun (Déjà Vu Edition)
Writing - be it a technical language like T-SQL, C#, PowerShell, etc. or blogging - is like exercise. When you do it...
2012-08-06
1,530 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...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
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