PowerBI for SQL DBA – Investigating Perfmon Counters

Introduction PowerBI Desktop is a free tool from Microsoft you can download here. Paid versions also exist for Cloud and on premise (your servers), to easily share reports and view them on any device, not just PC. It is used

Posted in BI Tagged with: , , ,

Crypto-virus resistent backup

Introduction Crypto-viruses encrypt your data. If it asks money (a ransom) to decrypt, we call them “ransomware”. They cannot encypt your SQL Server databases because sql data and log files are in use by sqlservr.exe process, but they can encrypt

Posted in Security and encryption Tagged with: , , , , ,

Query with optional filters (catch-all query)

In almost every database we have a process that filters the same data with different filters. Typically, query is within a stored procedure that has many filtering parameters that are optional. The problem is – a query optimized builds only ONE plan that will handle every filter combination you throw at it.

Posted in TSQL and SQL Client Code Tagged with: , , ,

Max Memory in SQL Server 2016 Standard Edition

What is the memory limit for Standard edition of SQL 2016? The answer you will most often get is 128 GB. But that answer is not correct, or very partially correct at best case. When you plan a new SQL

Posted in Data Engine

Table and Index Compression

Compression feature was reserved for Enterprise Edition of SQL Server. With SQL 2016 SP1 we get it in all editions, e.g. Standard Edition. But, it is not always easy to say will we benefit from compressing certain table/index/partition or not.

Posted in Data Engine

Speaking at SQL Saturday Ljubljana

I am honored to be selected to enjoy SQL Saturday in Ljubljana, Slovenia, as a speaker. http://www.sqlsaturday.com/567/Sessions/Details.aspx?sid=54373 It is a free event, so if you want to mingle and learn about SQL, this is the great place! Registration is mandatory,

Posted in Conferences

Speaking at Advanced Technology Days 2016

Congratulations! Your session Show me the cache! has been accepted for Advanced Technology Days 12! http://atd.mscommunity.hr/predavanja/#session_61 It will be interesting exploration of SQL Server’s caches, especially the most important ones: plan cache and buffer pool cache, Memory Optimized tables and

Posted in Conferences

Database Recovery from RAM

Introduction Recently I had a client who basically lost his SQL Server databases. I decided to share this experience with you, so you can use it if you ever find yourself in so tough situation. The client found out that

Posted in Transaction log and Recovery

Formatting TSQL code

How do I format my TSQL code? Everybody has it’s own preferences on formatting SQL or TSQL code. I follow few very simple rules to achieve better readability, less bugs and  – you wont’ believe – faster code execution! Code

Posted in TSQL and SQL Client Code

Speaking at conference Kulendayz 2015

4th of September I will hold a full-day preconference training about SQL Server 2016 performance tuning. It will be different, interesting, and hopefully funny. Real-life examples, way of thinking about the performance, and what are the ultimate limits of physical

Posted in Conferences
Visit Us On TwitterVisit Us On FacebookVisit Us On LinkedinVisit Us On YoutubeVisit Us On Google PlusCheck Our Feed