DaveConvery

The End of Privacy: Tragically Comical Edition

It’s hard to avoid privacy-based stories at the moment, with growing concern over government snooping and the limits of power. But where I’m based, in the UK, there’s a new, fully-privatised invasion of privacy. One marketing company has created an outdoor wi-fi basestation that grabs your phone’s MAC address as you pass, with the idea […]

2013-08-19

63 reads

Tuning People?

Database people are used to changing the hardware of the server on which a problem database resides, or making changes to indexes and database settings, but humans and their organisations are far more difficult to tune and optimise than databases.

3.83 (6)

2012-06-11

286 reads

Blogs

Fixing the PoSh Hotkey in ADS

By

I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...

Capture Execution Plans Only For Long Running Queries

By

I love questions. Most of all, I love questions I can answer. I spotted...

Daily Coping 28 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Query Issue

By MannyR

Hi all, new here. I was using Access and almost finished creating what I...

Only return first matches per Id and calculate difference of dates in minutes

By SQL_Kills

Hi,   I have a the below table, from the result set I only...

SQL server 2019 CU7 removal

By sqlfriend

I just learned Microsoft removed CU7 for SQL server 2019. That is too bad...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers