Exam Prep 70-463: Columnstore Indexes and Partitioning
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-12-04
1,297 reads
SQL Injection Issues–Password Hashing
I’ve got a demo for one of my talks that really highlights some issues we have with SQL Injection. It’s...
2014-12-04
1,394 reads
Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)
The SQL Server 2014 Buffer Pool Extension feature can extend the buffer pool space on to Solid State Drive (SSD), where data and index pages can be cached. There...
2014-12-04
31 reads
NUMA remote (foreign) memory access overhead on Windows, SQL Server and In-Memory OLTP
In NUMA (Non-Uniform Memory Access), processors in the same physical location are grouped in a node which has its own local node memory. In a NUMA based system, there...
2014-12-04
48 reads
How to Handle Dynamic Rowsets
Sometimes you have a stored procedure that returns a rowset, and you need to insert the rowset into a temporary...
2014-12-04
1,573 reads
SQL Saturday NYC Update 1
It has been one week now since SQL Saturday NYC was announced and the planning committee and myself are very...
2014-12-03
373 reads
The Modern Data Warehouse
The traditional data warehouse has served us well for many years, but new trends are causing it to break in...
2014-12-10 (first published: 2014-12-03)
11,567 reads
SSRS SharePoint Integrated Mode – Report Server URL
This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending...
2014-12-03
2,708 reads
T-SQL Tricks – Customizing SSMS Templates with Parameters
I wrote briefly about templates in Management Studio (SSMS), and showed the default templates that come with SQL Server. I...
2014-12-11 (first published: 2014-12-03)
7,056 reads
On Perspective
Perspective can make or break a career. Maintaining a proper perspective is very often the differentiating factor between a good...
2014-12-10 (first published: 2014-12-03)
5,661 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers