sexta-feira, 28 de agosto de 2015

The Essential Guide the SQL Server 2014: Clustered Columnstore Index

http://ift.tt/1JCyMXO

Learn about SQL Server 2014's enhanced columnstore index

In this Essential Guide to SQL Server 2014 series I’ve been covering the most important new features and enhancements that Microsoft added to SQL Server 2014. In the last column I covered the SQL Server 2014’s Backup Enhancements. In this column I’m going to cover the important enhancements to the columnstore Index. Microsoft introduced the columnstore index in SQL Server 2012 and it provided significantly improved performance for data warehousing types of queries.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

dbms_output.put_line not showing on Oracle Sql Developer

As I started doing some Oracle supports, I had to create a few scripts for testing "stuff". As on T-SQL the PRINT command does the trick, Oracle takes a few more bits of code:

  exec dbms_output.put_line('Your string here')

And guess what, nothing shows on SQL Developer:



As it turns out, the SERVER OUTPUT must be set to on. It's off by default. Nothing is simple enough if Oracle can complicate it, right?

Run the following command:

  SET SERVEROUTPUT ON;
  exec dbms_output.put_line('Your string here')

You can create a script with SET SERVEROUTPUT ON; and set it as your start up scrip in Tools\Preferences\Database, so everytime you connect to a server, the serveroutput is set to ON.



Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06

quinta-feira, 27 de agosto de 2015

Writing Perfmon data to SQL Server

http://ift.tt/1i5NxYR

Learn the tricks to get Perfmon to write performance counter data to SQL Server

Q: I’m trying to get Perfmon to write performance counter data to SQL Server. In Perfmon I’ve created a Data Collector and I set the Log format to SQL. I have also created a data source using the SQL Server Native driver but when I try to start Perfmon I get the error Call to SQLAllocConnect failed with %1.

A: I’ve found that you cannot use the SQL Server Native Client to log data to SQL Server from Perfmon. I have only had success when the data source that I created used the ODBC driver like you can see in Figure 1.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

A Replacement for Maintenance Plan Backups

http://ift.tt/1fIBoHF

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

The Myth About Estimated Execution Plans

http://ift.tt/1hI0f08

How you name things matters. As Buck Woody said about the original SQL Server documentation, Books Online, “They weren’t books and they weren’t online.” There are even more horrific examples. As was pointed out to me by Mike Dimmick on my blog, the name for Estimated Execution Plans puts people off.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

quinta-feira, 20 de agosto de 2015

Announcing our IT/DevConnections Data Platform and Business Intelligence Keynote Speaker Conor Cunningham

http://ift.tt/1JtpvTL

This year we’re excited to welcome Conor Cunningham, Partner Architect on the SQL Server Core Engine Team at Microsoft as our Data Platform and Business Intelligence Keynote Speaker to speak on features coming to SQL Server 2016.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

Looking forward to Containers

http://ift.tt/1NHnPnm

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

quinta-feira, 13 de agosto de 2015

SQL Select: FAQs about SQL Server 2014

http://ift.tt/1JWsVx0

Answers to your most frequently asked questions about SQL Server 2014
Answers to your most frequently asked questions about SQL Server 2014

read more



from SQL Server Pro http://ift.tt/1kCjeYg

quarta-feira, 12 de agosto de 2015

Dealing with an Inherited SQL Server

http://ift.tt/1PlpX5o

Get a quick must-do checklist for dealing with an inherited SQL Server system
Get a quick must-do checklist for dealing with an inherited SQL Server system

read more



from SQL Server Pro http://ift.tt/1kCjeYg