Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,745,302 DBAs, developers and SQL Server users

Rss
Headlines today   August 27, 2014

Stairway to PowerPivot and DAX - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.  Read more...
By Bill Pearson 2014/08/27 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 921 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/08/27 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 26,162 reads

Questions about T-SQL Expressions You Were Too Shy to Ask

Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?  Read more...
By Additional Articles 2014/08/27 | Source: SimpleTalk | Category: expressions
Rating: (not yet rated)  Rate this |   Briefcase | 3,497 reads
Previous headlines

SQL Server Service Engine fails to start after applying CU4 for SQL Server 2008 SP1

After performing an update on SQL Server, SQL Server Engine and SQL Agent stop responding.  Read more...
By Hilda E 2014/08/26 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,473 reads

SQL Saturday #340 - San Diego, CA

SQL Saturday is coming to San Diego on September 20, 2014. This event has a great speaker line-up which includes Itzik Ben-Gan, Grant Fritchey, and many others. Register while space is available.  Read more...
By Press Release 2014/08/26 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,848 reads

Big Data Technologists Transition to Customer-Facing Roles

As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.  Read more...
By Additional Articles 2014/08/26 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 3,971 reads

Auto Generating Multiple XML Files Using SSIS

An SSIS package that can generate an XML file for each record in an XML column in a SQL Server Database using the Source Script Component in a Data Flow Task.   Read more...
By C.J. Garcia 2014/08/25 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 2,613 reads

The Mindset of the Enterprise DBA: 8 Ways To Centralize Your Work

As well as standardizing and documenting, the enterprise DBA needs to centralize the management of systems. Joshua Feierman explains.  Read more...
By Additional Articles 2014/08/25 | Source: SimpleTalk | Category: dba skills
Rating: (not yet rated)  Rate this |   Briefcase | 5,725 reads

The Best Database Administrators Automate Everything

Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once it's gone, that's it, gone forever.  Read more...
By John Sansom 2014/08/22 (first published: 2012/04/06) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,796 reads

Management of Windows Azure SQL Databases via PowerShell with REST APIs

Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,886 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Stupid me #4 – The login is from an untrusted domain

After quite a while it has finally returned: another Stupid Me™®©! A reminder: Every time I do something “stupid”, which happens...  Read more...
By Koen Verbeeck 2014/08/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,338 reads
Question of the Day

SQL Server 2008 r2?

By Shiva N (AxSys) 2014/08/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 606 reads

If I execute this on SQL Server 2008 R2, what happens? (Choose 2)


DECLARE @tblname VARCHAR(30)=REPLICATE('A', 116)

SELECT @tblname = 'CREATE TABLE #'+@tblname+'(i int)'

PRINT @tblname

EXEC(@tblname)  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
SQLRNNR
423 21638 SSC-Insane  
2.
Eirikur Eiriksson
389 1680 SSCommitted  
3.
cruice
387 814 SSC Eights!  
4.
GilaMonster
343 42803 SSC-Forever  
5.
Koen Verbeeck
331 13605 SSChampion  
Latest forum posts