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 31 (307 total posts) < 1 second(s)
  • re: SQL 2008 ConfigurationFile.ini file - not just for unattended installs

    The proper place to seek help is MSDN. The SQL Server forums are found at https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqldatabaseengine. The forums are moderated and are specifically for problem resolution.
    Posted to John Paul Cook (Weblog) by John Paul Cook on November 4, 2014
  • BI Beginner: Creating SSIS projects for 64-bit Office

    SQL Server Data Tools for Business Intelligence (SSDT-BI) is the replacement for Business Intelligence Development Studio (BIDS). SSDT-BI is a 32-bit application. If you have 64-bit Office installed instead of 32-bit Office, you will encounter problems when attempting to create SSIS packages that use Excel files. This is easily resolved by ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on November 3, 2014
  • re: BI Beginner: Installing SSDT BI

    Thanks, Greg. I've had several people ask for help in &quot;finding&quot; the templates that used to be in BIDS, which is why I made this post.
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 30, 2014
  • BI Beginner: Installing SSDT BI

    The Business Intelligence Development Studio (BIDS) does not come with SQL Server 2014 like it did in previous versions of SQL Server. Furthermore, it has been renamed as SQL Server Data Tools Business Intelligence. If you have Visual Studio 2012, download this. If you have Visual Studio 2013, download this. I recommend that you download and save ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 30, 2014
  • In The Cloud: Creating Your First Azure SQL Database

    Creating your first SQL Database in Azure is quick and easy. There are a few things Ive discovered that might help you be successful faster. Many people have asked me how to get started, so Ive provided these steps to success. The steps I show you arent the only way to achieve success. This is an adaptation of one of my Azure demos. First, you ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 23, 2014
  • 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;original 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. ...
    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 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement