THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |

Search

You searched for the word(s):
Showing page 1 of 38 (371 total posts) < 1 second(s)
  • Row Level Security and Indexed Views

    I was giving my Row Level Security session last weekend for the Richmond User Group (@RichmondSQL&#160;http://rva.pass.org/) and a question came up (ok, so I technically asked the question). How does the feature work with indexed views? Generally speaking, the answer turned out to be obvious. You can apply a RLS Security Policy to a view that has ...
    Posted to Louis Davidson (Weblog) by drsql on August 13, 2017
  • Scenic City Summit is this Friday

    Scenic City Summit is a one day conference in Chattanooga, the Scenic City Summit is a new experience for me, although in a familiar, Devlink-esqe setting of the Chattanooga Convention Center in Chattanooga, TN. I am looking forward to attending, and seeing a couple of fellow Microsoft MVP's do keynotes: Cory House and David Neal. I have never ...
    Posted to Louis Davidson (Weblog) by drsql on July 24, 2017
  • 50ths… SQL Saturday and Life

    This week I will experience a couple of events associated to the number 50. SQL Saturday Atlanta The second will be my 50th SQL Saturday Event! (49th speaking, 1 attended in casual mode 50th speaking Saturday will be in August at SQL Saturday Louisville).&nbsp; This weekend is SQL Saturday Atlanta. It is one of my favorite events, not just for ...
    Posted to Louis Davidson (Weblog) by drsql on July 11, 2017
  • re: Creating FOREIGN KEY constraints as enabled, trusted, non-trusted, and/or disabled

    @Brenda Sorry I didn't see your comment earlier. I hope you see the latest post in the series. It really works pretty well. @John. You wouldn't really want them that way. But if you have a really large table, you may not be able to re-trust them all in some cases. It definitely will cause there to be less information about the columns for the ...
    Posted to Louis Davidson (Weblog) by drsql on July 11, 2017
  • SQL Saturday Chattanooga is THIS WEEK!

    My goodness how time does fly. It seems like just a few months ago I was going to my hometown SQL Saturday in Nashville, and now here I go again to my NEW hometown SQL Saturday in Chattanooga, TN. Much like the Nashville event, I didn't really do anything in terms of organization of the event, but I will be speaking at the event this year (last ...
    Posted to Louis Davidson (Weblog) by drsql on June 21, 2017
  • Father, Son, Daughter, and SQL

    I don't love Father's Day. Mostly because I spoke to my father for the last time on Father's day back in 1996. He wasn't feeling well, we exchanged a few pleasantries, and the words I remember were: &quot;I don't feel well, let me give you to your mother.&quot; Better than the actual last word's that Marshall got: &quot;that fungus thing is acting ...
    Posted to Louis Davidson (Weblog) by drsql on June 18, 2017
  • Utility to temporarily drop FOREIGN KEY constraints on a set of tables

    I was working on a database a few weeks back (maybe longer, I am kind of busy with several projects right now), and I wanted to truncate a set of tables. There was one central table, and 8 tables related by a FOREIGN KEY constraint. The central table had 6 million rows, and a few of the other tables 20+ million. TRUNCATE is amazingly fast,and when ...
    Posted to Louis Davidson (Weblog) by drsql on June 15, 2017
  • Utility to script a FOREIGN KEY Constraint

    Note: Amended to include the word include in the first Note (I am a terrible editor of my own writing!) and to fix a bug in the code with a misplaced parenthesis Note: Amended to include cascading and NOT FOR REPLICATION. As noted in my previous post, I am in the middle of building a utility (for work, and for my next SQLBLOG post), that ...
    Posted to Louis Davidson (Weblog) by drsql on May 24, 2017
  • Creating FOREIGN KEY constraints as enabled, trusted, non-trusted, and/or disabled

    I am in the middle of building a utility (for work, and for my next SQLBLOG post), that will help when you need to drop the foreign key constraints on a table, but then replace them without having to save off the script manually. Part of the process is to generate the script for the foreign key constraint, so the first thing I need to do is to ...
    Posted to Louis Davidson (Weblog) by drsql on May 7, 2017
  • Speaking at the Nashville SQL Server User's Group on April 28th.

    And they say you can't go home again.. On the 28th of April I will be returning back to my old home of Nashville to speak at the Nashville SQL Server User's Group. (And where I moved to was very near the home I lived in when I was in high school.) The session I will be doing is a one off session of demos of some of the new T-SQL features that ...
    Posted to Louis Davidson (Weblog) by drsql on April 18, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement