Latest Blog Posts
Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.
Filed under: Blog Tagged: DevOps, speaking, syndicated
One of the things that people have asked to be implemented for many years is an easy way to copy databases. SSIS has the Copy Database Task, but that has been problematic over time. As a result, while easy, it’s cumbersome to take a backup of a database, copy it… Read more
Good day everyone , In last post
we saw the what is In Memory OLTP and what are the requirements for that. In This post I will show you the demo of how we get performance gain.
The scripts (demo ) i will be using… Read more
One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to get my family, I’ll be reading…
Mr Robot killed the Hollywood hacker
Article on MIT Tech Review about how hacking is depicted in Mr Robot.
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface Pro 3 dev instance about every 30 to 60 seconds.
I opened object explorer to check if any jobs were running in SQL Agent that may be running DBCC FREEPROCCACHE Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
This is a quick post on checking the port for your SQL Server instance. It’s in line with Tim Ford’s request for simple, beginning blog posts this… Read more
I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the things I like best about it is that unlike the old Upgrade Advisor it doesn’t have to be run on the server being upgraded. You can run it against… Read more
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss why companies are deciding to move to SQL Server.
In our industry, we often hear people talking about being on or migrating to… Read more
Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free and doesn’t require any travel. You can watch the event live from the comfort of your office chair.
In the many years that we’ve run SQL in the City, we’ve… Read more
In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of SQL Server in containers.
This post follows on from Part Three in which we uploaded a custom image to the docker repository.
The three previous posts have all been… Read more
Trying to pull data from Oracle view using linked server and getting below error. It was only when I try with particular Oracle instance, when I try to pull data from other instance using the same view it is working fine.
I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page, they ask you to pick a language and OS. Since I’ve done a little Python and I used Windows, I chose that option.
The page looks to walk… Read more