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 31 (302 total posts) < 1 second(s)
  • Migrating Open Source Databases to SQL Server

    In my recent migration of a PostgreSQL database to SQL Server, I made several generic observations that I hope you will find helpful. I used the official PostgreSQL drivers found here. They did work and I was eventually able to use the Import and Export Wizard to load the data into SQL Server. Drivers that work with the Import and Export Wizard ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 12, 2014
  • SQL Server Backup to Azure

    Because so many people have asked me for specific details on backing up a SQL Server database to Azure, this post shows the necessary steps to accomplish that. The&nbsp;database name is MIMIC II, which is a&nbsp;clinical database that is available to researchers. It will be used in subsequent posts on data migration and machine learning. The ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 8, 2014
  • Antivirus and SQL Server

    Antivirus protection and SQL Server dont mix well. Some good tips on getting antivirus software to play nicely with SQL Server can be found here. Take a look, you might find something you havent considered.
    Posted to John Paul Cook (Weblog) by John Paul Cook on September 24, 2014
  • SQL Server Analytic Functions

    Last week I demonstrated SQL Server analytic functions at Houston TechFest. Below you will find an expanded set of code samples from my original content. As I explained in the presentation, I also used content from Itzik Ben-Gans excellent book from Microsoft Press, which I highly recommend. I also recommend Itziks columns at ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on September 21, 2014
  • AdventureWorks2014 installation script

    The AdventureWorks2014 sample database is downloadable from here. If you choose to run the script and are unfamiliar with sqlcmd, this post shows you what to do. Be sure to extract the zip files contents to a new folder because the instawdb.sql comes with 72 csv files that contain the actual data. If you specify a folder other than the default, ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on August 10, 2014
  • Surface Pro 3 first impressions

    I traded in my Surface 2 (the trade-in program is now over) and bought a Surface Pro 3 with an i7 processor and 8 GB of ram. I greatly prefer the 3 by 2 aspect ratio of the Surface 3. After only one day of ownership, Ive decided to purchase a docking station. I have a 7 year old desktop with a quad core Q6600 processor overclocked to 3.0 GHz and ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on August 3, 2014
  • Unsupported way to secure unsupported XP

    The free software tool nLite can be used to customize an XP installation. It isnt supported by Microsoft, but neither is XP. It is possible to remove Internet Explorer or networking components from an installation. Sometimes there is no need for the XP machine to ever connect to a network. This is particularly true when XP is used to host ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 22, 2014
  • Free Azure HDInsight ebook from Microsoft

    Microsoft has released a free ebook on Azure HDInsight. Full details are available here. HDInsight is Microsofts implementation of Hadoop. Azure HDInsight is Hadoop in the cloud. The ebook gives you a quick overview of what Big Data is and what you can do with it.
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 19, 2014
  • Windows 8.1 Boot into Desktop Mode

    If you primarily work in desktop mode, you can easily reconfigure Windows 8 to start in desktop mode when booting up. Once in desktop mode, go to the Taskbar, right-click and then select Properties to change the Navigation on your machine. Figure 1. Right-click on the Taskbar select Properties. On the Navigation tab, check When I sign in or ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 14, 2014
  • Windows Not Sleeping All Night

    Having a computer wake up when you dont want it to wastes electricity and drains the battery on mobile devices. My desktop had been waking up at night, so I assumed it was some network traffic on my home network. I unchecked Allow this device to wake the computer on my network adapters. Figure 1. Network adapter Power Management tab. That ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 18, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement