The SQL Server SOS_SCHEDULER_YIELD is a fairly common wait type and it could indicate one of two things: SQL Server CPU scheduler is utilized properly and is working efficiently or There is a pressure on CPU. Read more at the SQL Shack from Nikola Dimitrijevic..
Startup options designate certain file locations needed during startup, and specify some server wide conditions. Most users do not need to specify startup options unless you are troubleshooting the Database Engine. It might also be useful to add trace flags to a startup options. Trace flags are used to temporarily set…
SQL Server 2016 is finally here. The quickest way to experience the magic of SQL Server 2016 is to create a test environment using an Azure SQL VM. You can also experience the full features through the free developer edition (you will be prompted to sign in to Visual Studio…
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…