Sub query pass through
Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...
2013-03-26 (first published: 2013-03-22)
3,579 reads
Dave Ballantyne
SQL Saturday 194
On the weekend of the 9th March 2013, the second SQL Saturday in the UK occurred. A massive thank you...
2013-03-12
657 reads
A year of SQL Lunchs
Time does fly, and happy birthday SQL Lunch UK.
It has been a year since the first SQLLunch UK, and over...
2013-02-17
691 reads
Deploying SSRS artefacts using Powershell ( Simply)
As ive stated in the past, i’m presently part of a team on an ALM project for a major UK...
2013-02-12
3,951 reads
Photo cataloguer
If you are anything like me, by know you will have a few thousand digital images spread across multiple directories...
2013-01-20
726 reads
Scaling out SQLLunch UK
As you may be aware, I have been running a lunch time user group ‘SQLLunch UK’ having stolen drawn inspiration...
2013-01-11
659 reads
SSDT – TSQL Unit testing in multiple environments
Late in December, one the long awaited portions of functionality inside SSDT was released to an eager public, that being...
2013-01-07
1,744 reads
When is a whitespace not a whitespace ?
As I'm sure I must have mentioned in the past, I’m presently involved in a large ALM project at a...
2013-01-04
1,514 reads
My new favourite traceflag
As we are all aware, there are a number of traceflags. Some documented, some semi-documented and some completely undocumented. Here...
2012-12-06
981 reads
SQL Saturday 194 - Exeter
Many kudos goes to Jonathan and Annette Allen and the others on the team for confirming SQL Saturday 194 in...
2012-12-06
873 reads
Blogs
Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell
As AI continues to evolve, many of us are looking for ways to leverage...
Monday Monitor Tips: Finding the Hostname for Queries
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Can AI Read Execution Plans?
Yeah, yeah, second AI post in a row. I promise not to make a...
Forums
SSIS Won't Create Log Entries
Hi everyone My SSIS package will not log to sysssislog. I am not sure...
SQL Server is terminating in response to a 'stop' request from Service error
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Question of the Day
Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers