Last Week Reading (2019-01-13)
Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The...
2019-01-13
183 reads
Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The...
2019-01-13
183 reads
What popular tool has he created in 2006?
What popular tool has he created in 2006? How many people do live...
2019-01-11
180 reads
Azure Key Vault is a service which allows you to keep and manage passwords, certificates and other sensitive information securely....
2019-01-09
276 reads
Good morning chaps! Bunch of news from data’s world freshly served. Press Introduction to Testing Your PowerShell Code with Pester...
2019-01-06
159 reads
Good morning #sqlfamily folks! The very first post in the new year 2019. Tell me: when this time passed??? The...
2019-01-01
183 reads
The 2018 year is coming to the end. It’s a good time to review the passing year and… check whether...
2018-12-26
188 reads
The Christmas is coming. But before we start the festive time and sit down to the Christmas Eve dinner – a...
2018-12-23
181 reads
Hello data geeks. Last week we had many news about Cosmos DB, and this time the top topics are Power...
2018-12-16
177 reads
Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the...
2018-12-14
196 reads
What wasn’t really designed for people of guest’s stature? From who his every good decision does come from? New podcast...
2018-12-07
177 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;