Dynamically Read event_file Data
In the previous article I covered the basics on extracting the payload for the events in a session from the event_file...
2015-10-14
815 reads
Blog Posts
Dynamically Read event_file Data
There needs to be a more efficient means of grabbing the file without having to know the location. Knowing the session name should be adequate enough to parse the...
2015-10-14
8 reads
Getting Started With DocumentDB
I’ve put this off for too long. It’s time to get my feet wet with some new tech.
Step 1 is...
2015-10-14
564 reads
Handling decimal and non numeric types using Case statement
Hi Guys
Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the...
2015-10-14 (first published: 2015-10-06)
3,500 reads
Index selectivity and index scans
There was a question raised some time back ‘If an index is not selective, will the query operators that use...
2015-10-14 (first published: 2015-10-06)
4,370 reads
New SSDT Projects default to the latest version of SQL Server
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which is annoying when you are on something else.
However, if...
2015-10-14
2 reads
New SSDT Projects default to the latest version of SQL Server
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...
2015-10-14
65 reads
New SSDT Projects default to the latest version of SQL Server
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...
2015-10-14
37 reads
New SSDT Projects default to the latest version of SQL Server
When you create a new SSDT project it is created (at the moment) as a SQL Server 2014 project which...
2015-10-14
380 reads
Speaking at SQL Saturday #452 - Charlotte, NC - October 17
In case you missed it last week, there will be another SQL Saturday this weekend in Charlotte, NC. If you...
2015-10-14
509 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
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