SQL Sentry Pro Explorer is worth it…
UPDATE: 2015-04-28 15:49 – I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...
2015-04-22
302 reads
How Many SQL Log Files Do You Keep? - WaterOx Consulting
Reading Time: 2 minutesEver have this happen? You (on vacation): I’ll have another piña colada...
The post How Many SQL Log...
2015-05-05 (first published: 2015-04-22)
5,599 reads
Optimizing the Modern Data Platform with SQL Server 2014
Join Jason Strate and Pragmatic Works in Minneapolis on May 7. Learn about Optimizing the Modern Data Platform with SQ Server...
2015-04-22
543 reads
Overview of Published Articles – 2015Q1
Here is an overview of the articles I published in the first quarter of 2015.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...
2015-04-22
538 reads
Backup before you restore
You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.
A while back...
2015-04-22
504 reads
Make Sure to Schedule Your SQL Server Replication Jobs
You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done.
Right? Wrong..
At...
2015-05-04 (first published: 2015-04-22)
5,402 reads
How Do Blind People Use SQL Server?
#SQLNewBlogger
I can just see people skimming that and doing a knee-jerk reaction, “What a cruel and mean title! You should...
2015-04-22
1,031 reads
Padding Fields for Fixed-Position Data Formats
Fixed-position data formats will seemingly be with us forever. Despite the relative ease of parsing CSV (or other delimited formats), or even XML, many data exchanges require a fixed-position...
2015-04-22
21 reads
Outlier Detection with SQL Server, part 6.1: Visual Outlier Detection with Reporting Services
By Steve Bolton
…………Most of the previous articles in this self-tutorials on using SQL Server to find outliers required us to...
2015-04-21
1,747 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
475 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers