SSMS Keyboard Shortcut Fun
Andrea Allred (@RoyalSQL) just gave her SQL tips and tricks session at SQL Saturday Salt Lake City, and a great time was had by all! I learned some things...
2019-08-03
55 reads
Jen McCown
Fun with PowerShell: I made a game
So we got to playing around with PowerShell last week – one son is making a game hack, and the other...
2018-11-19
212 reads
Live blog: Women in Technology lunch at #PASSSummit #passwit
11:48am This will be starting shortly! We’re stuffing our faces, first. Today’s featured speaker is Lauri Bingham, Director of Technology Engineering...
2018-11-08
205 reads
SQL work-vacation, Thursday! (#Workation #PASSSummit)
Hello yet again! I’ve been writing about our time this week in Seattle, for the PASS Summit. Saturday, I wrote that we’re here...
2018-11-08
190 reads
SQL work-vacation, Monday (#Workation #PASSSummit)
Hello again! Sunday, I wrote that we’re here in Seattle for the PASS Summit, and that it’s my tenth year. AND that...
2018-11-05
190 reads
SQL work-vacation, T-2 days (#Workation #PASSSummit)
We are at PASS Summit 2018 in Seattle, and I will write a bit about each day I'm here, just...
2018-11-04
200 reads
Regular Expressions: tagging expressions
I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take...
2018-10-15
377 reads
sqlhelp: limit the x-axis of a geometry line graph
I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide...
2018-09-26
367 reads
More PowerShell for fun (and profit) – filter files by date
PowerShell provides an easy way to search for and/or delete just the files you want. Let's look at navigating in...
2018-09-24
736 reads
All about PASS Summit 2018
Here are the things you must/should probably know about PASS Summit 2018, as told by me. First Timers Read this...
2018-09-19
248 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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