Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught up, he asked me to explain in terms he could understand what I do for a living. I went through one of my spiels (the one usually..
Database Administrators can use the Transfer Jobs Task to transfer one or more SQL Server Agent Jobs between different SQL Server instances
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Steve Jones has attended a lot of conferences, including one recently in Austin. With the PASS Summit and SQL Connections coming up soon, he shares some reasons why a conference can be a great way to spend your training money.
Best-practice advice on software vs. coding, where to integrate, how to capture changed data, when to stage data, where to correct data and what latency levels to shoot for.
In the crusade to cut expenses, Data Centres (and IT Infrastructure) are now coming under scrutiny as a possible source of savings. Half-informed executives now rally behind the cry of "Virtualization!", but virtualization is only part of the story - The tip of the consolidation iceberg - and it might not actually save you as much as you think. Thomas LaRock takes us deeper.
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
Microsoft is very willing to lend its ear to new feature requests, but sometimes forgets to finish off the ones we've got.
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers