Yes, Table Variables and Temp Tables both use the tempdb
Pinal Dave recently wrote a blog post called SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth...
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Dissecting SQL Server Execution Plans
A review of MVP Grant Fritchey's "Dissecting Execution Plans". This is one book that you'll want on your bookshelf.
Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail
Learn how to create a certificate signed stored procedure to solve common permissions problems using sp_send_dbmail. MVP Jonathan Kehayias brings us a short tutorial that discusses your options and code to show you how to implement certificate security.
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Architecture Principles
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
Tally Table - Character Date Validation
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
Tool to help you analyze SQLDIAG and PSSDIAG output
SQLDIAG or PSSDIAG are excellent tools used to collect and analyze data in order to identify possible performance root causes. The issue is that the output produced by such utilities is sometimes convoluted, hard to read and hard to understand. In this tip, I will show you a tool that you can use to read and analyze the data collected by these tools.
How can we standardize SQL Server Data Deployments?
Some change requests, such as deploying a new stored procedure or trigger, are relatively easy to manage whereas others, such as data deployments, tend to thwart all attempts at standardization. And yet, there must be a way, and Rodney Landrum believes that DBA-developer co-operation lies at the heart of it.
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Alamat Kantor BCA KCU Gajah Mada Tlp:08218154374
Hub Via Wa:628218154374 Alamat: Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari,...
Alamat Kantor BCA KCU Pluit Telp:08218154374
Hub Via Wa:628218154374 Alamat: Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit,...
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers