How easy to determine table dependencies ? TIP # 86
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which ...
2015-02-24
518 reads
Blog Posts
How to Encrypt password in SQL Server ? TIP #87
Security is always a concern for every database developer. How to secure valuable information is one of the major and...
2015-02-24
421 reads
Identifying Blocking via Extended Events
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-02-24
361 reads
Outlier Detection with SQL Server, part 3.5: The Modified Thompson Tau Test
By Steve Bolton
…………Based on what little experience I’ve gained from writing this series on finding outliers in SQL Server databases,...
2015-02-24 (first published: 2015-02-14)
8,789 reads
Please Throw this Hardware at the Problem
We’re being told over and over that “throwing hardware at the problem” is not the correct solution for performance problems...
2015-02-24 (first published: 2015-02-12)
8,147 reads
Presentation slides for “Building a Big Data Solution”
Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop,...
2015-02-24
978 reads
Speaking at SQLBits and SQLRally
Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and...
2015-02-24
457 reads
SQL Cruise Caribbean 2015 Recap
UPDATED: Don't just take my word. Read the feedback from others.
SQL Cruise Caribbean 2015: More Than A Cruise With Classes....
2015-02-24
1,115 reads
Automating SSAS Backups
Backing up databases is one of the most important jobs of a DBA. If your data is not safe, your...
2015-02-23 (first published: 2015-02-11)
8,922 reads
Book Review: Virtualizing SQL Server with VMware
It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to...
2015-02-23
1,374 reads
Blogs
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....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
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