PASS Summit Precon – The Complete Primer to SQL Server Virtualization
I am very pleased to announce that Argenis Fernandez and I will be presenting a new precon training session at...
2015-07-10
556 reads
Blog Posts
Reblog: What’s the deal with Excel and SSIS?
SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to...
2015-07-10
1,342 reads
Script to find complete months between two given dates
Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05Enddate =2016-01-06
/**********************Script Start**************************/IF (object_id('tempdb..#month') is...
2015-07-10
17 reads
Script to find complete months between two given dates
Below script will help in finding the complete months within the 2 given dates. In the below script we takes...
2015-07-10
830 reads
Script to find the complete weeks within two given dates
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script,...
2015-07-10
22 reads
Script to find the complete weeks within two given dates
Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the...
2015-07-10
809 reads
SQL Server Infernals – Circle 3: Shaky Typers
Choosing the right data type for your columns is first of all a design decision that has tremendous impact on...
2015-07-10 (first published: 2015-07-02)
2,234 reads
Doing a Full Outer Join in Power Query
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities...
2015-07-09 (first published: 2015-07-02)
3,851 reads
Introduction To Dynamic Data Masking in SQL Server 2016
In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking. Using Dynamic...
2015-07-09
615 reads
Overview of Published Articles – 2015Q2
Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...
2015-07-09
535 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Alamat Telp BCA KCP Jamblang +62 838-4945-0961
Wa:083849450961 Jl. Jamblang Raya No.51, RT.2/RW.1, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah...
Telp BCA KCP Mandala Raya +62 838-4945-0961
Wa:083849450961 Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers