The $650 SQL Saturday
SQL Saturday #596 – Denver BI Edition was held on Feb 25, 2017. In keeping with my idea for a slimmer...
2017-03-24 (first published: 2017-03-07)
2,208 reads
Power BI Custom Visuals Class (Module 41 – Image Viewer)
In this module you will learn how to use the Image Viewer Power BI Custom Visual. The Image Viewer visual...
2017-03-14 (first published: 2017-03-07)
2,170 reads
Copying your SQL Database
If you ever need to move a copy of a SQL database in Azure across servers then here is a...
2017-03-07
359 reads
New Article – Application Database Security Design (Part 1 – Authentication)
In conjunction with the webinar I gave last month for MSSQLTips, I’ve started an article series on application database security...
2017-03-17 (first published: 2017-03-06)
2,139 reads
How Row versioning impact tempDB ?
Scenario: DBA found that tempdDBdatabase usage is getting high and most of the size is consumed by row versioning. DBA...
2017-03-06
2,645 reads
VMware Updates In-Guest Clocks When You Say Not To
VMware’s VMTools package has some options for synchronizing the in-guest clock with the time of the ESXi host. By default,...
2017-03-16 (first published: 2017-03-06)
821 reads
Dots, Skills, and SQL Clone: A Contest from Redgate
Redgate just launched SQL Clone, a new product that can provision copies of databases in seconds. By copies, I mean...
2017-03-15 (first published: 2017-03-06)
1,503 reads
SQL Clone and a Little Competition
Redgate has released a new product, SQL Clone. I’ve already talked about how excited I am about it. Now, it’s...
2017-03-13 (first published: 2017-03-06)
1,759 reads
Using GROUP BY instead of DISTINCT
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers GROUP...
2017-03-06
2,444 reads
SQL Server Fixed Role Permissions
It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database...
2017-03-06
27 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Tanah Abang Blok B Telp:0821°8200°233
Telp/Wa 628218200233 Gedung Pasar Tanah Abang Blok B Lantai 5 Kios Nomor 3, 5,...
Alamat BCA KCP Juanda III Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Ir. H. Juanda 3 No.34, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP Jembatan Lima Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Kh. Moch Mansyur No.15 F, RT.4/RW.1, Duri Sel., Kec. Tambora, Kota...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers