Looking back on 2014
When a new year comes around it is always a great time to reflect on the previous year.
2014 was a...
2015-01-06
421 reads
Blog Posts
Things I Learned in 2014
2015 is here!
Last year I wrote about what I had learned in 2013, and I try to make it a...
2015-01-06
756 reads
T-SQL Tuesday #62 - Invitation to HealthySQL
Greetings ALL and Happy New Year 2015! I wish everyone an excellent year ahead, and
that 2015 will bring peace and...
2015-01-06
5,911 reads
Using an alternate TypeScript compiler inside Visual Studio
TypeScript team member Daniel Rosenwasser provided instructions for replacing the TypeScript compiler and language service used by Visual Studio here:
https://github.com/Microsoft/TypeScript/issues/1110#issuecomment-62451204
He...
2015-01-06
1,167 reads
Website Updated
Over the Christmas holiday period the gethynellis.com website has had a bit of revamp.
In terms of what has changed,...
2015-01-06
407 reads
Beware of Login Issues for Privileged Accounts
In a recent post, I described an attack against a privileged account using a simple SQL Injection technique of updating...
2015-01-05
847 reads
Case of the Mondays... causing me to randomly redefine the Scope of Global temp tables
Today, I was reminded that global temp tables scope lasts for the session, and doesn't last beyond that. The difference...
2015-01-05
759 reads
Effects of Max Mem on Plan Cache
Some effects on plan cache and max memory settings
Related Posts:
The Curiously Large CASE Statement March 20, 2019
Maintenance Plan Owner - Back to Basics December 13, 2018
ArithAbort and...
2015-01-05
4 reads
Happy New Year 2015
I know it’s late but I’ve been away, I hope you all had a good Christmas and New Year.
I...
2015-01-05
640 reads
Las Vegas UG This week
What a fun week we have tuned up for the folks in Las Vegas. It is the first full week...
2015-01-05
541 reads
Blogs
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers