Off topic: The two cycle engine and your career path
I’ve been in technology for twenty years now. I’ve seen hundreds of environments, nearly 300 while employed at Microsoft alone.
One...
2016-12-30
784 reads
Blog Posts
Performance-Oriented SQL Server Development – The Scripts
Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.
It was a great experience,...
2016-12-30
921 reads
Easily Move Databases with Copy-SqlDatabase
One of the things that people have asked to be implemented for many years is an easy way to copy...
2016-12-29 (first published: 2016-12-09)
2,483 reads
How we can determine table column dependencies within a SQL database?
I came a situation during some analysis where i had to figure out all dependency of a column across database....
2016-12-29
4,305 reads
Looking Back At 2016
When this blog started back in 2011 I had no idea that it would continue to grow to where it...
2016-12-29
682 reads
Analysis Services and Power BI: Time-travel, Space-warping and Teleportation
As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. ...
2016-12-28 (first published: 2016-12-10)
1,557 reads
Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”)
Continuation from the previous 92 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given that currently the Batch Execution Mode...
2016-12-28
974 reads
DBA Resolutions
It’s said that “promises are made to be broken”. Surely database administrators don’t fall in that category? It’s that time...
2016-12-28
707 reads
ETL Error Handling
In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...
2016-12-28
773 reads
Post TDE–Getting Unencrypted Backups
I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup....
2016-12-28
2,175 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I