SQL Saturday 467 – Precon – Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
296 reads
Dave Ballantyne
Getting out of the ground with TSQL Smells.
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
672 reads
Increasing ColumnStore compression ratio for archival and “Cold storage”
At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This...
2015-03-17
355 reads
SQLBits, Incremental Statistics and Demo Fail
So another great SQLBits is done and dusted, many thanks to the team, helpers and sponsors for putting on such...
2015-03-08
462 reads
Non use of persisted data – Part Three
A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those...
2014-11-02
354 reads
Please please tell me now…
.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew...
2014-08-15
394 reads
Reasons why your plans suck : No 56,536
I have been working with SQL server for more years than I really care to mention and like to think...
2014-04-12
381 reads
T4 Support in SSDT
Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me. On tuesday night,...
2014-03-29
1,136 reads
Whats This Command Bar ?
One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...
2014-03-13
317 reads
On the move
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find...
2013-04-14
619 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 giving "Error converting data type varchar to float" error
Hi everyone The data provider I use to get data from changed their coding...
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