Kom igang med Machine Learning på Azure

Tekst kommer senere
3. August 2018/by iis_wwwsoakd_
billede mangler

Er machine Learning nonsens?

Machine learning, kunstig intelligens, billedgenkendelse etc.…
21. May 2018/by iis_wwwsoakd_
billedet mangler

PowerBI, PowerDit og PowerDat….. tiden er til Self service BI.

Med Microsoft Powerbi har Microsoft lavet et af de bedste produkter…
21. May 2018/by iis_wwwsoakd_

To faktor Authentication i PowerBI

Det er let, det er smart og det ser helt fantastisk ud, når…
21. May 2018/by iis_wwwsoakd_

Get started with SQL Server on Linux

The first time I heard about this, I thought it was a joke, but…
23. January 2017/by Soeren Agerbo

Primary Keys and clustered indexes

One of the common misunderstandings in relation to the Microsoft…
12. August 2014/by Soeren Agerbo

Expert Performance Indexing for SQL server 2012

One more book review 🙂 (It's really nice having a long…
11. August 2014/by Soeren Agerbo

Microsoft SQL Server 2012 Internals

This book is a "must have book", if you want to dig into…
11. August 2014/by Soeren Agerbo

Executionplan with crazy percentages

I got the following executionplan from a customer (IT IS AN ESTIMATED…
9. December 2013/by Soeren Agerbo

70-462 Chapter 10, Lesson 2: Concurrency

3. June 2013/by Soeren Agerbo

Exam 70-462 Chapter 10 Lesson 1: Indexes

Here is a short video about indexes in Microsoft SQL server 2012.

[youtube…
3. June 2013/by Soeren Agerbo

Exam 70-462 Chapter 11, Lesson 3: Restore

Here is a short video about restore for the 70-462 exam. My suggestion…
27. May 2013/by Soeren Agerbo

Exam 70-462–Chapter 11, Lesson 2: Backup

Here is a short video about backups and the required skills that…
27. May 2013/by Soeren Agerbo

Exam 70-462–Chapter 11, Lesson 1: SQL Server Agent

The SQL Server Agent is the scheduling tool for Microsoft SQL…
26. May 2013/by Soeren Agerbo

Exam 70-462–Chapter 7, Lesson 2: Replication

Below is a video that describes and show the different types…
26. May 2013/by Soeren Agerbo

MS SQL 2012 – Offset and fetch

(You must have the database adventureworks2012 installed. Download…
5. May 2013/by Soeren Agerbo

Practical Troubleshooting The database Engine

This book is an oldie, but a goodie, and I finally managed…
4. May 2013/by Soeren Agerbo

IAM Page Error – Fix it with a page restore

Today I have been playing around with situations, where your…
7. April 2013/by Soeren Agerbo

DBCC checkDB – A Nice trick to see progress

I hate the situation where I have started a DBCC CHECKDB and…
7. April 2013/by Soeren Agerbo

Waits and queues with a practical approach

Earlier I have been writting about Waits and queues and how to…
12. March 2013/by Soeren Agerbo

Extended events – Your first setup

Extended events are used to track down what happens in the SQL…
13. February 2013/by Soeren Agerbo

Unique identifer or INT as clustered index

Today I was asked about what is best to use for a clustered index…
20. December 2012/by Soeren Agerbo

Two ways of improving your ETL with SQL 2012 #3 Change data capture

In an earlier post we saw how the new project deployment functionality…
19. December 2012/by Soeren Agerbo

two ways of improving your ETL with SQL 2012 #2 – Project deployment

How did you deploy SSIS packages earlier? Well, I went into the…
19. December 2012/by Soeren Agerbo

Two ways of improving your ETL with SQL 2012 #1

SQL 2012 has improved a lot when it comes to the possibility…
19. December 2012/by Soeren Agerbo

Database mirroring–survival kit #4

This is the final part of database mirroring, and here I want…
18. December 2012/by Soeren Agerbo

Database mirroring–survival kit #3

Now it gets a little bit tricky, because how will you handle…
18. December 2012/by Soeren Agerbo

Database mirroring–survival kit #2

So, in the previous article about database mirroring, we saw…
18. December 2012/by Soeren Agerbo

Database mirroring–survival kit #1

This blog is intended to give you a short introduction to Database…
18. December 2012/by Soeren Agerbo

Problems with Parallelism

Sometimes the SQL server can  benefit of having multiple processors…
15. November 2012/by Soeren Agerbo

C2 Auditing–Enable

C2 auditing is easily enabled, by writing the following SQL Statement…
10. November 2012/by Soeren Agerbo

Setting up a database snapshot

A databasesnapshot is a point in time view of a given database.…
10. November 2012/by Soeren Agerbo

Setting up Transparent Data Encryption

Below I have posted all my code for setting up Transparent Data…
10. November 2012/by Soeren Agerbo

What are table hints and how are they used

A question that I often get is what a table hint is and how it…
10. November 2012/by Soeren Agerbo

Examining waits – some nice TSQL

I am not a fan of borrowing from others, but with this blog I…
10. November 2012/by Soeren Agerbo

Extended events– the objects

Before reading this blog, it might be a good idea to read the…
10. November 2012/by Soeren Agerbo

Your first extended event

Extended events are used to track down what happens in the SQL…
10. November 2012/by Soeren Agerbo

Merge replication – a beginners guide

If you want to share data between multiple databases, then replication…
4. November 2012/by Soeren Agerbo

Peer to peer replication – a beginners guide

If you want to share data between multiple databases, then replication…
4. November 2012/by Soeren Agerbo

Transactional replication – a beginners guide

If you want to share data between multiple databases, then replication…
4. November 2012/by Soeren Agerbo

Snapshot replication for beginners

If you want to learn a little bit about one of the types of replications,…
31. October 2012/by Soeren Agerbo

Instant file initialization

Some times you need to create larger databases, and it will be…
30. October 2012/by Soeren Agerbo

Index fragmentation

I have seen a lot of nice ways of handling index fragmentations,…
24. October 2012/by Soeren Agerbo

Microsoft® SQL Server® 2012 Pocket Consultant

This is the first time I would make a book review, where I am…
24. October 2012/by Soeren Agerbo

Bookreview – 70-462 Administering Microsoft SQL Server 2012 Databases

This is the book for Microsoft SQL 2012 exam 70-462, and compared…
22. October 2012/by Soeren Agerbo

I want to pass 70-461 – Querying Microsoft SQL Server 2012

Hi,

I just want to share some of the thoughts that I have…
22. October 2012/by Soeren Agerbo

TSQL – introduction – Working with data (4 of 4)

At this time you should be able to select data and working with…
17. September 2012/by Soeren Agerbo

TSQL – introduction – Working with objects (3 of 4)

In this chapter you will learn about DDL Queries. DDL (Data Definition…
17. September 2012/by Soeren Agerbo

TSQL – introduction – the Select statement (2 of 4)

This is part 2 of a series of 4 blogs, where I introduce you…
17. September 2012/by Soeren Agerbo

TSQL – introduction (1 of 4)

I have created this blog, for people that want's a small introduction…
17. September 2012/by Soeren Agerbo

Wow – The trick with ‘In Recovery’

Today has been one of these days where everything went wrong,…
11. April 2012/by Soeren Agerbo

SQL Server MVP – Deep Dive Volume 1

This is a crappy book, but you should buy it anyway.... It sounds…
11. April 2012/by Soeren Agerbo

10 steps to better performance

Hi,

I have decided to write 10 short blogs about performance…
10. April 2012/by Soeren Agerbo

Indexed views

Hi,
(You need the adventureworks 2008R2 database for this post).

One…
10. April 2012/by Soeren Agerbo

SQL Server 2012 – Installation 1

Funny to see the new version of SQL Server 2012 installation.…
13. January 2012/by Soeren Agerbo

70-433 – 000 – Introduction

Welcome to this series, where I will try to cover some of the…
22. December 2011/by Soeren Agerbo

Professional SQL Server 2008 Internals and Troubleshooting

It is very easy to give a description of this book. It is a…
19. December 2011/by Soeren Agerbo

Pro SQL Server 2008 Mirroring

This book review is about the book "Pro SQL Server 2008 Mirroring",…
2. December 2011/by Soeren Agerbo

Tipping point

YOU NEED ADVENTUREWORKS TO RUN THIS EXAMPLE:

When working…
16. August 2011/by Soeren Agerbo

A short introduction to Full Text Search

YOU NEED THE ADVENTUREWORKS DATABASE FOR THIS BLOG!!!!

I think…
11. August 2011/by Soeren Agerbo

Why Autoshrink is so bad

One of the interesting things about Microsoft SQL Server 2008…
5. August 2011/by Soeren Agerbo

Course at SQL Skills in Seattle – Day 3-4

2 more days of the course has gone, and this will be a very short…
5. August 2011/by Soeren Agerbo

Course at SQL Skills in Seattle – Day 2

Logfiles... What the f... It is just something that is there…
5. August 2011/by Soeren Agerbo

Course at SQL Skills in seattle – Day 1

Finally, the day arrived where the course would start, and let…
5. August 2011/by Soeren Agerbo

Course at SQL Skills in seattle – Day -1

Sunday... And one day before the start of the course. I am really…
3. August 2011/by Soeren Agerbo

Course at SQL Skills in seattle – Day -2

This is something I have been looking forward to for the last couple…
31. July 2011/by Soeren Agerbo

Recursion

recursion is one of the things that makes it easy to work with…
27. July 2011/by Soeren Agerbo

Why make it difficult

Some times it is not necessary to write long blogs to write about…
13. July 2011/by Soeren Agerbo

Defragmentation

I have been asked if there is a way to do a more intelligent…
8. July 2011/by Soeren Agerbo

Filestream for newbies

Filestream is one of the coolest new functionalites in SQL Server,…
7. July 2011/by Soeren Agerbo

when datatypes causes problems

When I visit my customers I often see the great DBA's trying…
28. June 2011/by Soeren Agerbo