The first time I heard about this, I thought it was a joke, but now I have been working with Microsoft SQL Server for Linux, for some time, and I think the idea is great. Why not have Microsoft SQL server on as many platforms as possible. Below I have describedÂ how I got my first […]
Author Archive for: Soeren Agerbo
About Soeren Agerbo
This author has yet to write their bio.Meanwhile lets just say that we are proud Soeren Agerbo contributed a whooping 67 entries.
Entries by Soeren Agerbo
One of the common misunderstandings in relation to the Microsoft SQL server is that a primary key always will be enforced with a clustered index. That is not true, and in the following video I demonstrate that.
One more book review ðŸ™‚ (It’s really nice having a long holiday to read books and relax). This is also a “Must have book”; simply because Indexing is so important for good performance. Indexing is always a trade off between better read access to data versus storage and degrade in write performance, and I think […]
This book is a “must have book”, if you want to dig into the SQL server. Not only because it is written by some of the most Genius SQL persons (Kalen Delaney, Jonathan Kehayias, Benjamin Nevarez and Paul S. Randal), but because with this book, you get deep dive knowledge about how the SQL Server […]
I got the following executionplan from a customer (IT IS AN ESTIMATED EXECUTIONPLAN) and as you can see, then the sum of the percentages is more than 100%. That should be impossible, but when I started to look into it, the reason was quite obviously: The shown executionplan shows the complete SQL statement, but only […]
Here is a short video about indexes in Microsoft SQL server 2012. [youtube https://www.youtube.com/watch?v=Ckm2rjIwOKk]
Here is a short video about restore for the 70-462 exam. My suggestion is that you try all the things, so that you learn them. [youtube https://www.youtube.com/watch?v=ev4BM7QQA9Q]
Here is a short video about backups and the required skills that you must aquire to take the exam 70-462. [youtube https://www.youtube.com/watch?v=XARnU-ShzIE]
The SQL Server Agent is the scheduling tool for Microsoft SQL Server 2012, and you must at minimum learn what a job and an alert is. If you donâ€™t know that, and if you canâ€™t setup a simple job and an alert, then you will not pass the exam. When you have learned the basics […]
Vi er Danmarks bedste Data hus, og vi tilsikrer at du altid fÃ¥r en god oplevelse nÃ¥r du handler hos os.
Skarpe priser, overholdelse af aftaler og en hÃ¸j faglig viden kendetegner vores virksomhed.
Foldegade 33, 7100 Vejle, Danmark
+45 71 74 11 00
Jyske Bank: 7248-0001407467