(Kenneth Fisher) I’ve you’ve run a query similar to the following:
Tag: sql server
10 New Features Worth Exploring in SQL Server 2016
(Greg Larsen) There is a lot of buzz around SQL Server 2016. Microsoft announced the release of SQL Server 2016 at the Microsoft Ignite Conference during the first week of May 2015. Since that time a number of Community Technical Previews (CTPs) have come out.
How to Confuse the SQL Server Query Optimizer
(Gail Shaw) There’s a very easy way to confuse the SQL Server query optimizer: write generic queries intended to be reused as much as possible.
My Thoughts on Cross Filtering in Power BI
(Jason Thomas) It’s amazing how much of an influence your upbringing can have on you and your preferences. I was the youngest in my family for almost 10 years (till my brother came along) and not to say, growing up, I was very much pampered by my mom.
SQL SERVER – Transparent Data Encryption and Frequently Asked Questions
(Pinal Dave) In the recent past, I have been traveling to Delhi to meet customers and also attend a few conferences which my company has been sponsoring. These travel experiences give me an opportunity to meet folks who read my blog regularly as a face-to-face interaction.
How to Confuse the SQL Server Query Optimizer
(Gail Shaw) There’s a very easy way to confuse the SQL Server query optimizer: write generic queries intended to be reused as much as possible.
My Thoughts on Cross Filtering in Power BI
(Jason Thomas) It’s amazing how much of an influence your upbringing can have on you and your preferences. I was the youngest in my family for almost 10 years (till my brother came along) and not to say, growing up, I was very much pampered by my mom.
SQL SERVER – Transparent Data Encryption and Frequently Asked Questions
(Pinal Dave) In the recent past, I have been traveling to Delhi to meet customers and also attend a few conferences which my company has been sponsoring. These travel experiences give me an opportunity to meet folks who read my blog regularly as a face-to-face interaction.
How to create a temporary Stored Procedure using TempDB
(Jack Vamvas) Question: I have to execute a stored procedure for troubleshooting – but permanent stored procedures are disallowed. Is there a way to create a temporary stored procedure – ?
Zombie AD Groups
(Kenneth Fisher) I spent something like 2 hours today trying to figure out how a particular user had access to one of my databases. It’s one of the strangest things I’ve ever seen while playing with SQL Server security. Here’s how it plays out:
