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
173 reads
Jen McCown
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
190 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
173 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
177 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
175 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
278 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
308 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
717 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
237 reads
Be in the SQL Yearbook
I’ve been thinking about this for years, and I’m finally doing it. I’m making a SQL Yearbook, and I want you to be...
2018-09-06
255 reads
Blogs
Using Azure Data Factory to Migrate Data
By Arun Sirpal
Quite simply the objective as follows: Move data from Azure SQL Database to Azure...
Strategies for Compliant Development Down Under
By Steve Jones
I’m doing a tour of Australia and New Zealand with our SQL in the...
Why is my pivot query not returning any data? How to debug a PIVOT query
By Ed Elliott
If you have a PIVOT query and it isn’t returning the data you expect,...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Passing Variables Between Procedures - Optimisation Question
Morning, I've inherited a system which passes a lot of variables around, and I'm...
Stored procedure executed from SSIS hangs. Works in SSMS and after drop-create
Hi, I have an Execute SQL task in SSIS which just fires a stored...
Ask SSC