Monday Coffee 2017-04-03
Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...
2017-04-03
142 reads
Monday Coffee 2017-04-03
Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...
2017-04-03
283 reads
Preconference Session at SQL Nexus – SQL Server Virtualization
If you are attending this year’s SQL Nexus conference in Copenhagen, Denmark, from May 1st to 3rd this year, I...
2017-04-03
428 reads
Custom Handling Flat File Output of an SSIS Package with the Script Component
I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...
2017-04-02
3,822 reads
Can I tune the tempDB of an Azure based SQL Server database…
Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...
2017-04-02
393 reads
Columnstore Indexes – part 101 (“Estimated? Similar! Similar How?”)
Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost will focus on warning you...
2017-04-01
409 reads
SQL Server DBCC CHECKDB
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
383 reads
Max Length of a column in a DataTable in PowerShell
Whilst I was writing my Test-DbaLastBackup Posts I ran into a common error I get when importing datatables into a...
2017-04-01
1,632 reads
April Fools 2017
Each year I try to something fun for April 1st, though it’s hard to do well. Trying to be funny...
2017-04-01
513 reads
Why I’m Changing to MySQLAndy
From time to time we all have to examine our path and decide if we need to make adjustments. Looking...
2017-04-01
429 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers