Lions and Tigers and Bears…
Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there...
2012-10-15
971 reads
Blog Posts
Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers
Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...
2012-10-15
409 reads
Microsoft Security Bulletin MS12-070 for SSRS
Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...
2012-10-15 (first published: 2012-10-09)
4,293 reads
Multilanguage Table, How to insert different language text in table ?
Issue :
Today, I received one request from my old friend.
He wants to insert text in different languages in table. He...
2012-10-15
2,988 reads
Office 2013 BI and Mobility
I had a really good experience presenting a session at the SQL Saturday BI Edition in Dallas this weekend about...
2012-10-15
855 reads
Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...
2012-10-15
1,822 reads
Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...
2012-10-15
34 reads
SQL Saturday #145 Nashville – Recap
This month has been wild. I’ve been out of town quite a bit for work, and started the month with...
2012-10-15
813 reads
Using SQL Server 2012 FileTables
Reblogged from Basit's SQL Server Tips:
SQL Server 2012 allows you to store file/directories in a special table called FileTable that...
2012-10-15
1,035 reads
Database Design Contest at the 2012 AITP Region 3 Student Conference
Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette. 31 different teams submitted database...
2012-10-14
976 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