This post is in support of Tim Ford’s (b|t) #iwanttohelp challenge. And also written because this has burned me twice in the past 3 months and by blogging about it, hopefully it’ll stick in my mind. Setup I’ve recently been doing a bunch of work with stored procedures, trying to improve performance that’s been suffering due…Read More Don’t Count on Me
It’s 2016. So why are we still dealing with T-SQL code and design patterns that were designed 7 versions ago? In the 15 years I have been using databases professionally, we’re still dealing with: Peoples’ names are split into first name, last name and middle initial fields. Ignoring that this falls afoul of several of the…Read More T-SQL Tuesday #83: Why Leave Well Enough Alone?
Something in SQL Server that isn’t always obvious to beginners is that when you create a default value for a column on a table, SQL Server creates a constraint (much like a primary or foreign key). All constraints must have a name, and if one isn’t specified SQL Server will generate one for you. For…Read More Name Your Defaults So SQL Server Doesn’t
This week’s #sqlnewblogger posts! Author Post @eleightondick [T-SQL Tuesday] Data modeling: The trouble with prefixes | The Data Files @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug Automatically name primary key constraints in SSDT | the.agilesql.club @rabryst Born SQL on Twitter: “Temporal Tables – Under the Covers with the Transaction Log. @YatesSQL Community Involvement–Why Wait?…Read More SQL New Blogger Challenge November 2015 Edition – Week 3 Digest
I have a situation where I need to retrieve the data in an encrypted column from, but don’t want to give all my users access to the symmetric key used to encrypt that column. The data is of the sort where it’s important for the application to produce the required output, but if a user runs…Read More Selectively Locking Down Data – Gracefully
This week’s #sqlnewblogger posts! Author Post @arrowdrive Anders On SQL: T-SQL Tuesday #72: Data modelling gone extremely wrong @rabryst Time After Time – An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean @EdDebug Deploy SSDT INSERTS in Batches | the.agilesql.club @ALevyInROC Don’t Trust the Wizard @DBA_ANDY Nebraska SQL from @DBA_ANDY: T-SQL Tuesday…Read More SQL New Blogger Challenge November 2015 Edition – Week 2 Digest
If you need to move data from one table into a new table, or even tables in a database into another database, the Import/Export Wizard in SQL Server Management Studio looks pretty tempting. Set up a source & destination, click a few buttons, kick back with a cup of tea and watch the progress bars,…Read More Don’t Trust the Wizard
Ed Leighton-Dick has renewed his New Blogger Challenge this month. Here are all (I think) the posts for this week after Ed posted his announcement. If I’ve missed any, please let me know and I’ll update. Author Post @arrowdrive Anders On SQL: First Timer Summit impressions. @EdDebug Deploy SSDT INSERTS in Batches | the.agilesql.club @EdDebug Looking at…Read More SQL New Blogger Challenge, November Edition, Week 1 Digest
Spend any time around a 4 year old, and you will inevitably find yourself involved in a conversation which evolves into this: Please do this thing Why? Reasonable answer Why? Restatement of reasonable answer Why? Shorter, more frustrated restatement of reasonable answer Why? Because that’s what has to be done Why? Because Why? I give up.…Read More Why Ask Why?
So you’ve decided that your new web application needs to record some page load time metrics so you can keep tabs on performance. Terrific! You set up a couple page load/complete functions to write to a logging table when a page request comes in, and then update the record when it finishes loading. [code lang=”sql”]INSERT INTO PageLogs…Read More Hello GETDATE() My Old Friend…