This month’s T-SQL Tuesday is hosted by Brent Ozar and he’s asked everyone to find interesting bug or enhancement requests in Microsoft Connect related to SQL Server. The Connect item doesn’t have to have anything to do with T-SQL – it could be about the engine, SSRS, R, the installer, whatever. Now, more than ever, Microsoft has…Read More T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests
Odds are, you’ve got more than one application or script accessing your database or SQL Server instance at any given time. You’re probably stacking them on a small number of servers in an attempt to cut down on licensing costs and resource usage. All those Powershell scripts running on the central job server are running…Read More Make Your Application’s Name Heard
The Rochester, NY chapter of PASS is holding our 6th annual SQL Saturday on April 29th, 2017! As always, RIT is hosting our event on campus.
SQL Saturday is a free day of training centered on the Microsoft Data Platform. Volunteer speakers come from all over the country (and sometimes beyond) to share their knowledge with attendees. There are sessions available for professionals of all skill levels, whether you’re just starting to learn about databases or a seasoned veteran, in addition to valuable professional development guidance.
Why should you attend?
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