THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 32 (312 total posts) < 1 second(s)
  • Use AutoCorrect in Word to Prevent SQL Sever

    Too often I see SQL Server misspelled as SQL Sever. You can easily prevent this by using AutoCorrect in Word. Start by clicking on File. Figure 1. Click on File in Word. Next, click on Options. Figure 2. Click on Options. On the Word Options dialog box, select Proofing and then click the AutoCorrect Options button. Figure 3. Click the ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 7, 2016
  • re: Aggregating Aggregates and UNION vs. UNION ALL

    Readers who need specific help should go to MSDN forums for SQL Server or Stack Exchange.
    Posted to John Paul Cook (Weblog) by John Paul Cook on April 4, 2016
  • SQL Server 2016 Temporal Queries Sample Code

    Temporal tables in SQL Server 2016 and Azure SQL Database allow you to have historical changes to data maintained for you automatically. You dont have to write custom code to maintain historical values. New SQL syntax allows you to query and retrieve the data as it was in the past or you can simply retrieve the most recent value. The official ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on March 31, 2016
  • SQL Server 2016 Documentation Survey

    The SQL Server product team wants to hear from you. Heres your chance to say what you expect from documentation. Hurry the survey closes on March 18.
    Posted to John Paul Cook (Weblog) by John Paul Cook on March 15, 2016
  • SQL Server on Linux–sign up for the preview

    SQL Server runs on Linux now. Apply for the preview at
    Posted to John Paul Cook (Weblog) by John Paul Cook on March 7, 2016
  • SQL Server, @@VERSION, and Hyper-V

    Yesterday my friend Kalen Delaney asked me about @@VERSION showing (HYPERVISOR) even though she wasnt running inside a virtual machine. I was able to replicate the behavior on my machines. I asked my colleagues at Microsoft about this. It was confirmed that it is by design. The addition of (HYPERVISOR) to the output indicates only whether or not ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on March 7, 2016
  • Protecting Credit Card Data

    Although the latter part of this post discusses Always Encrypted in SQL Server 2016, Im starting with the topic of protecting your own credit cards. I have a certain credit card that will remain nameless that we use for as many purchases as possible because of the cash rebate it offers. Its like electronic cash to us and always paid in full. ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on January 23, 2016
  • Storage Health Check

    Would a drive failure inconvenience you? Have you checked your old drives? Maybe it is time you should run some diagnostics. Before installing a new, larger SSD and making a completely fresh installation of Windows, I thought it would be a wise idea to check the status of my existing storage devices. Most of my drives are from Seagate, so I ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on December 22, 2015
  • re: Surface Pro 3 first impressions

    For running R and SQL, I recommend Surface Pro, not Surface. If your laptop works, wait just a little bit longer for Surface 4 instead of Surface 3 because of better performance and battery life. A docking station is nice to have but not a must. A higher end Surface Pro is suitable as a desktop replacement for many power users. If you need a lot ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 22, 2015
  • Privacy Settings: The Good, The Bad, and The Ugly

    Ive spent more time than Ive wanted today looking for and fiddling with privacy settings. Social media users cant have privacy, but there are at least some things we can do to reduce annoyances from having an online presence. Targeted advertising is something I find disturbing. I dont want to shop online and later have social media present ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 18, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement