THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 30 (299 total posts) < 1 second(s)
  • 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 http://sqlmag.com. ...
    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
  • Web-based data generator

    One of my coworkers told me about Mockaroo, a web-based data generator. I needed some test data for upcoming blog posts, so I decided to give it a try. Its pretty good. I had to use Firefox because of problems running Mockaroo on Internet Explorer 11. Using the defaults except for changing the format to SQL, it generated output that looked ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 16, 2014
  • TechEd 2014 Day 4

    Many people visiting the SQL Server booth wanted to know how to improve performance. With so much attention being given to COLUMNSTORE and in-memory tables and stored procedures, it is easy to overlook how important tempdb is to performance. Speeding up tempdb I/O improves performance. The best way to do this is to not do the I/O in the first ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 16, 2014
  • TechEd 2014 Day 3

    There is some confusion about durability of data stored in SQL Server in-memory tables, so some review of the concepts is appropriate. The in-memory option is enabled at the database level. Enabling it at the database level only gives you the option to specify the in-memory feature on a table by table basis. No existing tables or new tables will ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 14, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement