Positivity
I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a...
2016-02-04
563 reads
Columnstore Indexes – part 76 (“Compression Delay”)
Continuation from the previous 75 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
While playing with SQL Server 2016 CTP...
2016-02-04
800 reads
Recertifying SQL Server 2012 MCSE with Microsoft Virtual Academy
Do people still get certified? I don’t hear much about it in the SQL community these days so I asked...
2016-02-04
514 reads
Loading a Text File with a Line Feed
Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but...
2016-02-04
1,233 reads
SQL Server Reporting Services 2016 – Part 1
This first post of 3 takes a quick peek at SSRS 2016 using the Community Technical Preview (CTP) 3.2. I...
2016-02-03
1,350 reads
Scaling Azure SQL Database
One of the advantages Azure SQL Database has over on-prem SQL Server is the ease in which it can scale. I’ll...
2016-02-03
808 reads
Blogger questions: What if someone else wrote about the same subject?
I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a...
2016-02-03
574 reads
The Future of SSMS
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...
2016-02-03
632 reads
Limitation of In-Memory OLTP in SQL Server 2016 – TRUNCATE table not supported
Hi friends, another limitation that we will discussed is TRUNCATE table command is not supported with memory optimized tables. Let’s...
2016-02-03
1,398 reads
Should I use option(recompile)?
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of...
2016-02-02
6,994 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