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 29 (282 total posts) < 1 second(s)
  • re: Scammers on the loose pretending to be Microsoft

    The scammers are most probably dialing sequentially trying every possible phone number. Just because they say they can hack a computer doesn't mean they can. Pay no attention to these scammers. As long as you don't install their software or go to their website, the most they can do is waste your time.
    Posted to John Paul Cook (Weblog) by John Paul Cook on April 18, 2014
  • SQL Server 2014 Backup to the Cloud

    Backing up SQL Server to the cloud makes a lot of sense, particularly for small businesses. Managing the physical media takes up too much time and effort for a small shop. Azure storage simplifies the backup process allowing a small business to allocate its limited resources more effectively. As I was preparing this post and editing the screen ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on April 17, 2014
  • Windows 8.1 Usability Enhancements

    If your copy of Windows 8.1 is set to automatically install updates, you may have missed that you now have new usability enhancements to improve the user experience for both using a mouse and working in desktop mode. You can easily pin modern apps to your taskbar by right clicking a live tile. Figure 1. After right-clicking the Skype live tile, ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on April 12, 2014
  • SQL Server 2012 and 2014 Management Differences

    Whenever a new version of SQL Server is released, I compare what is in SQL Server Management Studio to get an overall, visual representation of the differences. There are of course differences that arent readily apparent by comparing whats in SSMS. The scope of this post is limited to the differences that are apparent in putting the different ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on April 12, 2014
  • Security in the Cloud including HIPAA

    Im increasingly recommending cloud based strategies to both drive down costs and simplify things. Cloud technology is now at a point there there are very clear guidelines and frameworks for addressing security concerns. Take a look at the Microsoft Azure Trust Center for a list of all of the security certifications Microsoft has earned. Notice ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on April 6, 2014
  • re: GUID, fragmentation and performance: the eternal flame.

    How about guid performance in an in memory database, which is latch free?
    Posted to Davide Mauri (Weblog) by John Paul Cook on April 6, 2014
  • Performance and Security Implications of 8.3 File Names

    While testing exports of SQL Server tables to files, one thing led to another and I started investigating the file server where the files are saved. Finding files on the server seemed slow. Further investigation revealed several MSDN and TechNet posts on how 8.3 file names adversely affect both file enumeration and creation performance. This post ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on April 4, 2014
  • BI Beginner: Power Query and OData

    Ive observed that not very many data professionals are familiar with OData. Its an open data access protocol built on AtomPub and JSON. It provides a RESTful means of retrieving data, which is what this post is about. One of the things that makes OData important is that it is recommended by the Open Government Data Initiative. Although this ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on March 29, 2014
  • BI Beginner: Use Power Query To Get Data From Web Pages

    Weve all seen data on a web page and wished we had it in Excel. Copying a table from a web page and pasting it into Excel often leads to disappointing results. Power Query makes it easy to import data from a web page into Excel. As a nurse, Im particularly interested in analyzing public health data for research purposes. I found some good data ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on March 13, 2014
  • re: Comparison of SSMS and Visual Studio for Development

    The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)&nbsp;That's the message I see when I try to debug on any of the servers at my primary client. This is not uncommon to see&nbsp;such restrictions.&nbsp;When the&nbsp;required permissions aren't ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on March 10, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement