Collation: Expression
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-04-02 (first published: 2014-03-26)
1,748 reads
Getting an INDEX SEEK to Speed up LIKE “%string%” Searches
In today’s blog I will attempt to challenge the popularly held notion that LIKE “%string%” wildcard searches must be slow...
2014-03-26
20,708 reads
Conditional Coloured Bar Charts in Excel with Upper and Lower Targets
I was just trying to gauge my BI knowledge level the other day and decided to chart it for visibility....
2014-03-26
587 reads
5 Top Features Your Company Can Use in SQL Server 2014 Standard Edition
In a few days SQL Server 2014 will be made available, we’re not all lucky enough to be running Enterprise...
2014-03-26
1,163 reads
Pluralsight = Essential Training
Update: 11th Sep 2016 - See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight...
2014-03-25
1,361 reads
5 Tools Every DBA Should Know About
After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day...
2014-04-03 (first published: 2014-03-25)
7,365 reads
Encryption in Las Vegas – SQL Saturday #295
I enjoy Las Vegas, usually trying to see a show of some sort when I’m there. I’ll have the chance...
2014-03-28 (first published: 2014-03-25)
1,545 reads
Book: Reporting with Microsoft SQL Server 2012
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012...
2014-04-04 (first published: 2014-03-25)
3,871 reads
Save Money On Your Training Server
You can spend less money. Some of us are lucky. We work for very large corporations who can easily set...
2014-03-31 (first published: 2014-03-25)
2,204 reads
What is Microsoft Management Reporter for Dynamics AX?
It is a collaborative and interactive reporting solution from Microsoft for finance data. View more here: Management Reporter 2012 Overview...
2014-03-25
777 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
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...
Forums
Alamat Telp BCA KCP Bona Indah +62 838-4945-0961
Wa:083849450961 Plaza Bona Indah Jl. Karang Tengah Raya Blk B/12, RT.1/RW.6, Lb. Bulus, Kec....
Alamat Telp BCA KCP Cirendeu +62 838-4945-0961
Wa:083849450961 Jl. Raya Cirendeu No.14, Cireundeu, Kec. Ciputat Tim., Kota Tangerang Selatan, DKI Jakarta...
Alamat BCA KCP Altira Sunter Telp 0821 6277 387
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, RT.9/RW.11, Sunter Jaya,...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers