I’m working with AlwaysOn Availability Groups in SQ’L 2014. One of the many interesting gotchas I have with AlwaysOn is that SQL Logins on each AG node must be created with identical SIDs, otherwise after failover the database users for those SQL Logins will be orphaned. I discovered Bill Graziano’s post back from 2010 where he scripts out […]
Category: SQL
All about Structured Query Language
Installing sqlcmd without SQL Server
I just ran into a need for sqlcmd without SQL Server. I’m on Windows Server 2016 Datacenter. I installed Microsoft® ODBC Driver 11 for SQL Server – Windows, with filename msodbcsql.msi Installed from https://www.microsoft.com/en-us/download/details.aspx?id=36434 This is a dependency for Microsoft Command Line Utilities 11 for SQL Server, with filename MsSqlCmdLnUtils.msi I installed from https://www.microsoft.com/en-us/download/details.aspx?id=36433 I chose the 64-bit versions of both. […]
Install SQL Express 2014 or 2016 from PowerShell
This may be useful for some folks out there. While the documentation on SQL Books online for command line installs is extensive, the examples there are limited, and the troubleshooting steps are not described clearly. You will need to download the SQL installer iso or files and mount or extract them, and locate the setup.exe. […]
Presenting SQL and PowerShell for South Florida CodeCamp 2016
Presentation scripts and resources here at the SFCodeCamp.com presentation OneDrive under ‘SQL and PowerShell’
My first book review! SQL Server 2014 with PowerShell v5 Cookbook
Has been a very busy year for me, haven’t posted lately, but was very excited to share this. I’ve had the opportunity to be a technical reviewer for three PowerShell books this year! One that I’ve really enjoyed reviewing has just been released, and the publisher Packt is offering an end of year sale for $5 eBook […]
SQL 2016 CTP2 is out, with Technet Virtual Labs ready to learn!
Microsoft just released SQL 2016 CTP 2. CTP is a customer technology preview, that lets us explore new features of the product before it’s released to marketing (RTM). I found it in my MSDN new downloads. Not ready to download and install it but still want to learn? Technet Virtual Labs already has SIX virtual […]
Scripting COMPLETE Full-Text indexes after a database restore
You may find yourself working with SQL 2000 databases, or later versions of SQL that were migrated from SQL 2000, with the Full-Text indexes stored outside the SQL data files. In this scenario, once you restore a SQL Server database, your full-text catalogs and the full-text indexes within are not restored along with your data. […]
Off to SQLPASS 2013!
This year I’m volunteering at SQL PASS Summit 2013 as an MCT Volunteer, to assist those interested in certifying for SQL Server 2012. Being an MCT means keeping up with certifications, which means keeping up with tests, and since 2002 I’ve certified on SQL 2000,2005 and 2008. This May I achieved my MCSE: Data Platform this […]
Presenting on SQL 2014 New Features
Life has been so busy, haven’t kept up with the blog. Have been researching SQL 2014 new features for CTP1, lots of great material out there. Presenting today at New Horizons in Fort Lauderdale
Free SQL 2012 hands on learning!
Tech Ed 2013 is over, and now the fun begins for those who could not attend. Dozens of Hands-On labs are available online for us to learn new technologies! Here’s a list of the SQL 2012 Hands-On Labs I’m starting with the Hekaton lab!