Νοέμβριος 2013 - Δημοσιεύσεις
I have been delivering a certified course in MS SQL Server 2012 recently and I was asked a very interesting question about SQL Server stored procedures and ownership chain . Security is a big thing in SQL Server and can be implemented in various levels.
Διαβάστε περισσότερα
I have been delivering a certified course in MS SQL Server 2012 recently and I was asked a very interesting question "If there is a way to find using T-SQL tables in a database that have no clustered indexes or no indexes at all" I have answered that
Διαβάστε περισσότερα
I have been delivering a certified course in MS SQL Server 2012 recently and I was asked a very interesting question about SQL Server pages and what types of pages exist. I had to explain to them about SQL Server architecture first. Each data file is
Διαβάστε περισσότερα
I have been delivering a certified course in MS SQL Server 2012 recently and I was asked a very interesting question "Does the order of the column in an index matter?" Let's give some basic definitions first and make some analogies. A single column index
Διαβάστε περισσότερα
I have been delivering a certified course in MS SQL Server 2012 recently and I have found something that was really impressive regarding SET options in SQL Server and index creation. I will look into the SET QUOTED_IDENTIFIER and SET ANSI_NULLS options
Διαβάστε περισσότερα
I have been delivering a certified course in MS SQL Server 2012 recently and I was asked to provide a demo about the MERGE statement. I will provide you with a demo in this post trying to explain more about the MERGE T-SQL statement and its use. This
Διαβάστε περισσότερα
In my last SQL Server 2012 administration seminar, I used Performance Monitor to analyse and troubleshoot issues regarding SQL Server. It is built into Windows and many administrators used it a lot in the old days when some of the tools we have now in
Διαβάστε περισσότερα
In this post I will talk about SQL Server Traces, what they are and how we can use them. An SQL Trace is a low-level server-side event inside SQL Server that can be used to audit activity,troubleshoot performance debug T-SQL statements and stored procedures.With
Διαβάστε περισσότερα
I have just finished a seminar in SQL Server 2012 and one of the topics I have explained thoroughly was Trace flags. In this post I will try to shed some light on what trace flags are and how we can use them. Trace flags are used to change the behavior
Διαβάστε περισσότερα
I have just finished a seminar in SQL Server 2012 where the topic of "indexes" was again a very highly discussed topic. At one point I had to present a demo on covering indexes . In this post I will try to shed some light on covering indexes and their
Διαβάστε περισσότερα
I have just finished a seminar in SQL Server 2012 and some of the people attending it (from all walks of life) were asking me about dirty pages,what they are and if I can provide a demo. I will try to explain what dirty pages are and how they are flushed
Διαβάστε περισσότερα
Recently in one of my SQL Server seminars, I was asked to give a short introduction and a demo on SQL Server Extented events. In this post I will explain what Extended Events are and provide a hands on demo. SQL Server Profiler is (was) the main tool
Διαβάστε περισσότερα
In a recent seminar I gave regarding SQL Server 2012 I was asked to clear a few things regarding SQL Server 2012 editions and their license options/pricing. In this post i will shed some light on this issue. I will start by talking about the various license
Διαβάστε περισσότερα
I had a seminar in SQL Server 2012 recently and one of the people in my class asked me what is the best way to restore a In this post I will like to shed some light on the issue. As we all know we must include in our backup strategy, the system databases
Διαβάστε περισσότερα