SQL Server databases consist of two physical files types; the data file in which the data and the database objects such as tables and indexes are stored, and the transaction log file in which SQL Server stores records for all transactions performed on that database. SQL Server transaction log contains…
The SQL Saturday team of Indianapolis would like to introduce the SQL Starter Track. An entire track of FREE sessions geared towards the ABSOLUTE BEGINNER. Be sure to sign up We have also started the #SQLStarter on Twitter. Find out more information on on our Sway Page.
Desired State Configuration is a PowerShell extension that ships with Windows Server 2012 R2 and Windows 8.1. Why is PowerShell Desired State Configuration (DSC) so cool. Well to borrow from this Technet Blog here are a few reasons. First of all declaring a DSC configuration is PowerShell based. So you can…
I could only go back 12 years, but I was curious what percentage of my students took each of my classes. If I could have included 2000-2003, I am sure there would have been a little more Visual Basic. I think the Office classes are over-represented since those were only…
Here is a Sneak Peek Preview of SQL Server 2016 and Cortana Intelligence by Tim Ford at SQL Server Magazine.The biggest features in the new edition of SQL Server are Always Encrypted, Stretch Database, integrated R language support in SQL Server, Cortana Intelligence, and the SandDance data visualization tool.
People frequently ask, “Where can I learn more about PowerShell?” Today’s post will highlight popular video training options available directly from Microsoft. Click here for more information.
So I have not done a college update in about 6 months. Due to a few work projects, I had to push back my last two classes. The Integrated Science class took about 3 months to get through, just because of the sheer amount of information in the class. I…
Wow, Paul Randal has put together probably the most comprehensive library of all wait types and latch classes that have existed since SQL Server 2005. This will be extremely important to all the Performance Tuners out there to really understand what is slowing your SQL code down. I can’t believe…
During this 30-minute webinar from January 13, 2016, Jeremy Cioara, Garth Schulte, and Ben Finkel compare and contrast Amazon Web Services, Google Cloud Platform, and Microsoft Azure — three of the leading cloud platforms on the market. You’ll learn what features the three share, what features help them stand out,…
Microsoft is currently offering two new ways to support IT professionals and their companies in a smooth transition to the cloud: Microsoft IT Pro Cloud Essentials and Microsoft IT Pro Career Center. The IT Pro Cloud Essentials and the IT Pro Career Center are the two newest programs to help IT…