T-SQL Tuesday – Non-SQL Server Technologies
So, this month’s T-SQL Tuesday topic is to think about a non-SQL Server technology that we want to learn.
For me,...
2018-11-15 (first published: 2018-11-06)
2,148 reads
So, this month’s T-SQL Tuesday topic is to think about a non-SQL Server technology that we want to learn.
For me,...
2018-11-15 (first published: 2018-11-06)
2,148 reads
A while back I wrote a post, Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Recently Manish...
2018-11-08 (first published: 2018-10-30)
2,532 reads
One of the common goto methods for query specific slowness which can be replicated via an application can be to...
2018-11-05 (first published: 2018-10-24)
2,171 reads
Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right? ...
2018-10-25 (first published: 2018-10-16)
2,048 reads
It has been long overdue but finally V1.2 is now available on GitHub.
V1.2 brings a lot of changes, We put...
2018-10-10
363 reads
Pre-requisites:
SQL 2012 or higher
SQL Server Agent
A database to store the the data collected by the agent jobs (this can be...
2018-10-10
286 reads
I recently came across a really odd issue with the SQL Agent, there were two agent jobs attached to one...
2018-10-11 (first published: 2018-10-02)
2,845 reads
In my recent post, Installing External Modules into SQL Server’s Python I had a look at just how simple it is to...
2018-09-18
494 reads
It’s the second Tuesday of the month which must mean only one thing…
We’re all skint and payday feels like a...
2018-09-11
264 reads
For those of you who don’t have time to watch the videos, the audio stream of our webcasts are now...
2018-09-05
293 reads
By Steve Jones
1202– n. the tipping point when your brain becomes so overwhelmed with tasks you...
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
Comments posted to this topic are about the item The Journey to Change
Comments posted to this topic are about the item Check Azure SQL DB Space...
Comments posted to this topic are about the item The Cloned Database Size
I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:I now run this command:
DBCC CLONEDATABASE(sandbox, sandbox_clone); GOWhen I examine the database file properties, what do they show? See possible answers