Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/07/29 to 2013/08/05

Changing SQLServerCentral - Initial Thoughts

We have been considering lots of changes at SQLServerCentral, but we would like to get comments and feedback from the community as we move forward. This is the start of an series looking at potential and current changes.  Read more...
By Steve Jones 2013/08/05 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,484 reads

Growing Your SQL Server Skills without Breaking the Bank

Learning more about SQL Server doesn't have to cost a small fortune. If you're willing to invest the time, you can learn.   Read more...
By Mike Hillwig 2013/08/05 | Source: SQLServerCentral.com | Category: learning
Rating: |  Discuss |   Briefcase | 10,400 reads

Using Microsoft Excel to Retrieve SSAS Tabular Data

Although it is well-known how to create a tabular database in PowerPivot, it is less obvious that there are several useful options for retrieving SSAS tabular data into Excel. This provides an easy way of manipulating, visualizing and analyzing the data without needing to know the details of SSAS and the tabular model.  Read more...
By Additional Articles 2013/08/05 | Source: SimpleTalk | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,498 reads

New SQL Monitor Custom Metric: Failed SQL Server logins

This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour.  Read more...
By Press Release 2013/08/02 | Source: Red-Gate | Category: red gate
Rating: (not yet rated)  Rate this |   Briefcase | 3,376 reads

SQL Saturday #235 New York City, NY

Come to SQL Saturday New York on August 17 for a day of free SQL Server training and networking. Some of the speakers at this event include Chris Bell, Ben DeBow, Ashish Sharma, and Hilary Cotter  Read more...
By Press Release 2013/08/02 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,550 reads

The Big Data DBA

Many IT enterprises are starting pilot projects to implement big data solutions. This article highlights what you need to know to check if you're ready to support these efforts, and integrate them into your current architecture, processes, and standards.  Read more...
By Additional Articles 2013/08/02 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 3,109 reads

Sorting Months By Number (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.  Read more...
By Jeff Moden 2013/08/02 (first published: 2010/11/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,918 reads

Intervals and Counts - Part 1

When using SQL Server, you frequently need to work with data that represents intervals of time. For example, consider intervals representing sessions, contracts, projects, and so on. Tasks related to interval manipulation are typically quite intriguing, especially because coming up with efficient solutions isn't easy. Itzik Ben-Gan explains  Read more...
By Additional Articles 2013/08/01 | Source: SQL Server Magazine | Category: interval
Rating: (not yet rated)  Rate this |   Briefcase | 3,830 reads

Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)

Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.  Read more...
By Brandie Tarvin 2013/08/01 | Source: SQLServerCentral.com | Category: generate scripts
Rating: |  Discuss |   Briefcase | 3,157 reads

Disaster Recovery Tip #8: Maintain up-to-date contact information

A corollary to Murphy's Law states that disaster is most likely to strike when your senior people are out of the office.  Read more...
By Press Release 2013/08/01 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 3,392 reads

Biml Workshop presented by Varigence and Linchpin People

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. On October 15th come see why BI professionals around the world think Biml is the future of data integration and BI.   Read more...
By Press Release 2013/08/07 (first published: 2013/07/17) | Category: events
Rating:  Rate this |   Briefcase | 5,933 reads

Biml Basics - Level 2

The next step in the stairway to Biml teaches you how to build a basic SSIS package using the scripting language.  Read more...
By Andy Leonard 2013/07/31 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,887 reads

SQL Saturday #234 Baton Rouge, LA

SQL Saturday is coming to Baton Rouge for a free day of SQL Server training and Networking on August 3. There is also a pre-conference session presented by Bill Pearson on Practical Self-Service BI with PowerPivot for Excel on August 2nd.  Read more...
By Press Release 2013/07/31 (first published: 2013/07/19) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,586 reads

Baselining with SQL Server Dynamic Management Views

When you're monitoring SQL Server, it's better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problems becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started.  Read more...
By Additional Articles 2013/07/30 | Source: SimpleTalk | Category: baselines
Rating:  Rate this |   Briefcase | 3,777 reads

Enable/Disable a table to be read only on the fly

Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?  Read more...
By Steven Rao 2013/07/30 | Source: SQLServerCentral.com | Category: read only
Rating: |  Discuss |   Briefcase | 6,902 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2014/05/28 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 23,738 reads

SQL Saturday #236 St Louis, MO

SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.   Read more...
By Press Release 2013/07/30 (first published: 2013/07/24) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 4,308 reads

Using Lookup Function to Bridge Datasets in Report Builder

The report function, lookup, can be used to link two independent datesets.  Read more...
By Jeffrey Li 2013/07/29 | Source: SQLServerCentral.com | Category: lookup
Rating: |  Discuss |   Briefcase | 4,002 reads

VMware High Availability in SQL Server

With the massive number of servers running SQL Server within virtual machines (VMs), it's critically important for DBAs to understand the high availability options available when SQL Server is running within a VM.   Read more...
By Additional Articles 2013/07/29 | Source: SQL Server Professional | Category: vmware
Rating: (not yet rated)  Rate this |   Briefcase | 3,052 reads