SSDT all the way
I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local database instance and then test the actual code in...
2015-02-16
18 reads
Blog Posts
SSDT all the way
I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...
2015-02-16
56 reads
SSDT all the way
I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...
2015-02-16
686 reads
SSDT all the way
I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...
2015-02-16
34 reads
Consolidating time series metadata for users in Tabular
Background
DAX offers many powerful time intelligence functions that can be applied at virtually any level of a date / time hierarchy....
2015-02-13 (first published: 2015-02-04)
6,652 reads
Friday Followup For February 13, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-02-13
388 reads
T-SQL UNION Set Operator
T-SQL UNION
Set operators allow you to combine data from two or more queries and return the results in a single...
2015-02-13 (first published: 2015-02-04)
8,689 reads
Choosing a Development IDE for Sql Development
NOTE: THIS WAS WRITTEN IN 2015, it is now 2020 - that is 5 years so please consider this a historical artifact that is probably out of date. In...
2015-02-12
16 reads
Choosing a Development IDE for Sql Development
In this series of blog posts, I am talking about how to use agile or modern development practices to help...
2015-02-12
47 reads
Choosing a Development IDE for Sql Development
In this series of blog posts, I am talking about how to use agile or modern development practices to help...
2015-02-12
915 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Surya Kencana Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers