How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
39 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
41 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is...
2015-10-12
1,414 reads
Columnstore Indexes – part 68 (“Data Loading, Delta-Stores & Vertipaq Compression Optimisation”)
Continuation from the previous 67 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is focusing on some...
2015-10-11
461 reads
Hekaton Part 8 - Hash Collisions - Hash_Index_Stats DMV
Continuing from previous post , this post will discuss a few scenarios on hash collisions.
The following "in memory" table with a hash...
2015-10-11
609 reads
SQL Saturday #453–Minnesota 2015–A Window Into Your Data
Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...
2015-10-10
470 reads
Indexed views on any core SQL server edition-The video
A few months back I created a blog post showing that you can indeed create and use indexed views on any core SQL server edition. It has proved to...
2015-10-10
14 reads
Indexed views on any core SQL server edition-The video
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
202 reads
Indexed views on any core SQL server edition–The video
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
464 reads
SQL server encryption – Certificates
In the previous blogs we saw how to encrypt data using symmetric and asymmetric keys. We saw how to use...
2015-10-10
828 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers