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 (314 total posts) < 1 second(s)
  • Using SSMS in Customer Presentations

    When using SSMS with a projector or very large screen HDTV, there are several customizations to make things easier to read for the people in the back of the room. First lets look at a screen capture of SSMS without any customizations. Figure 1. SSMS with default settings. Do you really need the Properties pane during a presentation? Probably ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 27, 2016
  • BI Beginner: Using Power BI Desktop Instead of Excel for Visualizing Big Data

    Excel is a great tool but Power BI offers more in the realm of visualization. The 64-bit version of Excel is better at processing large files than the 32-bit version, but even it has limitations. Power BI Desktop (BI as in Business Intelligence) is a free alternative to Excel for working with large files and Big Data. It is possible to enable the ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 2, 2016
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement