Sqlnewblogger

This week’s #sqlnewblogger posts!

Author	Post
@eleightondick	[[T-SQL Tuesday] Data modeling: The trouble with prefixes
@tomsql	Adventures With TomSQL, aka Tom Staab
@EdDebug	[Automatically name primary key constraints in SSDT
@rabryst	Born SQL on Twitter: “Temporal Tables - Under the Covers with the Transaction Log.
@YatesSQL	[Community Involvement–Why Wait?
@cjsommer	[Identity Column Increment Value (EVEN/ODD)
@DBA_ANDY	Nebraska SQL from @DBA_ANDY: CHECKDB - The database could not be exclusively locked to perform the operation
@ALevyInROC	Selectively Locking Down Data – Gracefully – The Rest is Just Code
@eleightondick	[SQLNewBlogger, Week 3
@tomsql	Being Our Collective Best
@SQLMickey	[T-SQL Tuesday #72 Summary – Data Modeling Gone Wrong

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
@ALevyInROC	Don’t Trust the Wizard
@DBA_ANDY	Nebraska SQL from @DBA_ANDY: T-SQL Tuesday #72 - Implicit Conversion Problems
@eleightondick	[SQL New Blogger Challenge: Week 1 recap
@eleightondick	[SQL New Blogger Challenge: Week 2 ideas
@BeginTry	[SQL Server 2012 Upgrade: The RPC Server is Unavailable

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
@EdDebug	[Looking at SSDT upgrade scripts
@DBA_ANDY	Nebraska SQL from @DBA_ANDY: PASS Summit 2015 Recap
@eleightondick	[PASS Summit 2015 Highlights
@OliverAsmus	[PASS Summit 2015: My Experience
@EdDebug	[ScriptDom Visualizer
@eleightondick	[SQL New Blogger Challenge: Looking back… and a new challenge!
@Clem1029	[Tearing down the wall
@ALevyInROC	Why Ask Why?
@rabryst	The SQL Server Family

This week marks the end of Ed Leighton-Dick’s New Blogger Challenge. It’s terrific seeing everyone sticking with the challenge all month and I’m looking forward to catching up with all the posts. Great job, everyone! Keep going!

Author	Post
@MtnDBA	[#SQLNewBlogger Week 4 – My 1st SQLSaturday session
@Lance_LT	[“MongoDB is the WORST!”
@ceedubvee	A Insider’s View of the Autism Spectrum: Autism and Information Technology: Big Data for Diagnosis
@Jorriss	A Podcast Is Born
@toddkleinhans	[A Tale of SQL Server Disk Space Trials and Tribulations
@arrowdrive	Anders On SQL: First “real” job with SQL.
@arrowdrive	Anders On SQL: Stupid Stuff I have done. 2/?. Sometimes even a dev server is not a good dev environment
@way0utwest	[April Blogger Challenge 4–Filtered Index Limitations
@ALevyInROC	[Are You Backing Everything Up?
@DesertIsleSQL	[Azure Data Lake: Why you might want one
@EdDebug	[BIML is better even for simple packages
@tpet1433	Corruption – The Denmark of SQL Instances – Tim Peters
@eleightondick	[Creating a Self-Contained Multi-Subnet Test Environment, Part II – Adding a Domain Controller
@MattBatalon	[Creating an Azure SQL Database
@pshore73	[Database on the Move – Part I
@pmpjr	[Do you wanna build a cluster?!
@DwainCSQL	[Excel in T-SQL Part 1 – HARMEAN, GEOMEAN and FREQUENCY
@AalamRangi	[Gotcha – SSIS ImportExport Wizard Can Kill Your Diagrams
@toddkleinhans	[How Do Blind People Use SQL Server?
@DBAFromTheCold	[In-Memory OLTP: Part 4 – Native Compilation
@AaronBertrand	It’s a Harsh Reality - Listen Up - SQL Sentry Team Blog
@GuruArthur	Looking back at April - Arthur Baan
@nocentino	Moving SQL Server data between filegroups - Part 2 - The implementation - Centino Systems Blog
@MyHumbleSQLTips	My Humble SQL Tips: Tracking Query Plan Changes
@m82labs	Reduce SQL Agent Job Overlaps · m82labs
@fade2blackuk	Rob Sewell on Twitter: “Instances and Ports with PowerShell http://t.co/kwN2KwVDOS”
@DwainCSQL	[Ruminations on Writing Great T-SQL
@sqlsanctum	[Security of PWDCOMPARE and SQL Hashing
@Pittfurg	SQL Server Backup and Restores with PowerShell Part 1: Setting up - Port 1433
@cjsommer	[Using PowerShell to Export SQL Data to CSV. How well does it perform?
@gorandalf	[Using SSIS Lookup Transformation in ETL Packages
@nicharsh	Words on Words: 5 Books That Will Improve Your Writing

We hear the common refrain among DBAs all the time. Back up your data! Test your restores! If you can’t restore the backup, it’s worthless. And yes, absolutely, you have to back up your databases - your job, and the company, depend upon it.

But are you backing everything up?

Saturday night was an ordinary night. It was getting late, and I was about to put my computer to sleep so I could do likewise. Suddenly, everything on my screen was replaced with a very nice message telling me that something had gone wrong and my computer needed to be restarted.

Here are the posts collected from week three of the SQL New Blogger Challenge. It’s been compiled the same way previous weeks’ posts were. Everyone’s doing a great job keeping up with the challenge!

Author	Post
@MtnDBA	[#SQLNewBlogger Week 3 – PowerShell Aliases
@ceedubvee	A Insider’s View of the Autism Spectrum: Autism and Information Technology: New Efforts for Kids to Code
@arrowdrive	Anders On SQL: Stupid Stuff I have done. 2/?. Sometimes even a dev server is not a good dev environment
@way0utwest	[April Blogger Challenge 3 – Filtered Indexes
@eleightondick	[Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking
@ceedubvee	[Empower Individuals With Autism Through Coding
@MattBatalon	[EXCEPT and INTERSECT…
@cjsommer	[Follow the yellow brick what? My road to public speaking.
@DBAFromTheCold	[In-Memory OLTP: Part 3 – Checkpoints
@MattBatalon	[Introduction to Windowing Functions
@nocentino	Moving SQL Server data between filegroups - Part 1 - Database Structures - Centino Systems Blog
@Lance_LT	[My first year as a speaker
@MyHumbleSQLTips	My Humble SQL Tips: Tracking Page Splits
@ALevyInROC	Padding Fields for Fixed-Position Data Formats
@tpet1433	Sir-Auto-Completes-A-Lot a.k.a. how to break IntelliSense, SQL Prompt and SQL Complete – Tim Peters
@pmpjr	[stats, yeah stats.
@DwainCSQL	[Stupid T-SQL Tricks – Part 3: A Zodiacal SQL
@cathrinew	Table Partitioning in SQL Server - Partition Switching - Cathrine Wilhelmsen
@gorandalf	[The MERGE Statement – One Statement for INSERT, UPDATE and DELETE
@SQLJudo	[The Road to SQL Server 2014 MCSE
@GGreggB	[T-SQL Tuesday #65: FMT_ONLY Replacements
@AalamRangi	[What is the RetainSameConnection Property of OLEDB Connection in SSIS?
@EdDebug	[What Permissions do I need to generate a deploy script with SSDT?
@_KenWilson	[Windowing using OFFSET-FETCH
@DesertIsleSQL	What Does Analytics Mean?
@DesertIsleSQL	Azure ML, SSIS and the Modern Data Warehouse
@DesertIsleSQL	Musing about Microsoft’s Acquisition of DataZen and Power BI
@GuruArthur	Check for database files not in default location