Deleting Files Older than X Hours with PowerShell
(aka "OMG I can't believe I am actually finally writing a #PowerShell blog post").
--
I currently have a situation at a...
2015-04-15
33,571 reads
Blog Posts
HammerDB Performance Collection with SQL Server
Recently, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL Server that...
2015-04-15
1,166 reads
Have you tried DLM Dashboard?
DLM Dashboard is a new product from Redgate Software that’s free. Free as in beer, which should be attractive to...
2015-04-15
927 reads
How Do You Visualize Abstractions?
#SQLNewBlogger
Some time ago, my kids asked me what I do for a living. I told them I work with databases.
“What’s...
2015-04-15
606 reads
Null, empty string, or zero?
The answer: It Depends.
One of the more common problems I encounter when managing data quality, especially in an ETL process,...
2015-04-15 (first published: 2015-04-06)
7,571 reads
Quickly Check If SSL For SQL Is Enabled - WaterOx Consulting
Reading Time: 2 minutesTo quickly check SSL is configured on your SQL Server you can...
The post Quickly Check If SSL...
2015-04-15
696 reads
SQL New Blogger Digest - Week 2
I didn’t intend for last week’s digest to also be my post for week two of the challenge, but life got in the way and I wasn’t able to...
2015-04-15
5 reads
SQL Prompt – Killing the Detail Box
I love SQL Prompt and use it constantly. When I don’t have it, my code writing process slows to spurts...
2015-04-15
744 reads
Types of NoSQL databases
A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the...
2015-04-15
1,760 reads
Announcing Pro SQL Server Wait Statistics
I am very proud to officially announce my first ever SQL Server related book, Pro SQL Server Wait Statistics! As...
2015-04-14
642 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers