I’ll be presenting tomorrow at Nova Southeastern University – 9:50am Room 2081 (Carl DeSantis Building)

Hi, I just received the news that I got selected to speak at Nova Southeastern University tomorrow, 2/10/18 at 9:50am in Room 2081 (Carl DeSantis Building). Here’s the event info: http://fladotnet.com/codecamp/Home.aspx Register here (FREE): https://eventbrite.com/e/south-florida-code-camp-2018-tickets-38099337143 Pls fwd this invite to your friends and colleagues if you think they’ll be interested in attending. There will be… Continue reading I’ll be presenting tomorrow at Nova Southeastern University – 9:50am Room 2081 (Carl DeSantis Building)

My Schedule @ PASS Summit 2017

Here's my week's schedule - narrowed down with help of friends, for my 1st time at SQL PASS Summit 2017 in Seattle, WA. Here's the full conference schedule: http://www.pass.org/summit/2017/Sessions/Schedule.aspx My Schedule: Precon: Mon: Data Modeling with Power BI (603, Marco) Tues: Columnstore Indexes – Practical Solutions & Techniques (606, Niko) Conf: Wed: 1015am: Benchmarking & Testing In-Memory OLTP… Continue reading My Schedule @ PASS Summit 2017

SQL Server 2016 Always Encrypted – Parameterized Samples

With Always Encrypted in SQL Server 2016, if you want to Insert, Update or Filter by an encrypted column (ie. DML) the statement must be parameterized and/or use sp_executesql. Jakub shows how to do this on his post at the SQL Server Security Blog, but here's the condensed version of the article with all the sample scripts/instructions… Continue reading SQL Server 2016 Always Encrypted – Parameterized Samples

SQL Sync Logins – Domain Accounts

Hypothetically, say you can't grant dbo permissions. Instead you just need read, write and execute for stored procedures. Common Database-Level Roles are: db_datareader, db_datawriter, and my personal favorite db_executor. Ideally, you would use a domain security group (making the accounts members of the group) and grant the group access to the SQL Server instead of… Continue reading SQL Sync Logins – Domain Accounts