<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 1,641,681 DBAs, developers and SQL Server users
Headlines today
June 19, 2013
An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services
In this level of the Integration Services Stairway article, Andy Leonard examines SSIS variables.
Read more...
By
Andy Leonard
2013/06/19
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
3,207 reads
Review: Stellar Phoenix SQL Database Recovery
Stellar Phoenix SQL Database Recovery Software Review
Read more...
By
Prett Sons
2013/06/19
|
Source:
SQLServerCentral.com
|
Category:
reviews
Rating:
|
Discuss
|
Briefcase
|
363 reads
Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.
Read more...
By
Additional Articles
2013/06/19
|
Source:
MSSQLTips.com
|
Category:
recovery model
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,059 reads
Show more
Previous headlines
Usage of CTE - Trick with Dates
This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.
Read more...
By
Suresh Maganti
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
cursor vs recursive cte
Rating:
|
Discuss
|
Briefcase
|
11,440 reads
Attention users running SQL Server 2008 & 2008 R2!
Updates to the latest CUs for SQL Server 2008 and SQL Server 2008 R2 from Aaron Bertrand.
Read more...
By
Press Release
2013/06/18
|
Source:
SQL Blog
|
Category:
cumulative updates (cu)
Rating:
(not yet rated)
Rate this
|
Briefcase
|
6,141 reads
PASS Data Architecture Virtual Chapter presents Steve Simon
On Thursday June 20 at 12 noon Central time, Steve Simon will discuss the challenges of designing financial warehouses.
Read more...
By
Press Release
2013/06/18
|
Source:
PASS
|
Category:
pass virtual chapters
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,540 reads
Managing Slowly Changing Dimension with MERGE Statement in SQL Server
Slowly Changing Dimension (SCD) Transformation is a quick and easy way to manage smaller slowly changing dimensions but it has several limitations and does not perform well when the number of rows or columns gets larger. Arshad Ali explores some of the alternatives you can use for managing larger slowly changing dimensions.
Read more...
By
Additional Articles
2013/06/18
|
Source:
Database Journal
|
Category:
slowly changing dimension
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,702 reads
PowerShell vs GUI Availability Group Rebuild
Windows Cluster\SQL Availability Group rebuild times comparison - Management Studio & Cluster Manager Vs PowerShell Commands
Read more...
By
Paul Brewer
2013/06/17
|
Source:
SQLServerCentral.com
|
Category:
windows cluster
Rating:
|
Discuss
|
Briefcase
|
2,046 reads
Getting Started with the SSAS Tabular Model
SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to provide a rapid and powerful way of providing self-service BI to client applications such as Microsoft Excel and Microsoft Power View. You’ve deployed SSAS in tabular mode, and deployed Adventureworks into it. What next? Rob Sheldon explains all.
Read more...
By
Additional Articles
2013/06/17
|
Source:
SimpleTalk
|
Category:
ssas
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,642 reads
SQL Saturday #229 - Dublin
SQL Saturday Dublin is hosting a two-day training event covering SQL Server 2012, Business Intelligence, Database Administration and Personal Development. The free training event will be Saturday June 22 2013, and three preconference sessions (not free) will take place the 21st.
Read more...
By
Press Release
2013/06/17
|
Source:
SQLServerCentral.com
|
Category:
sql saturday
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,676 reads
From the SQLServerCentral Blogs
ORDER BY the numbers
Have you ever needed to order by a calculated column? You might have written it something like this: SELECT LoginID, YEAR(HireDate)...
Read more...
By
Kenneth Fisher
2013/06/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,426 reads
Browse all
Question of the Day
SQL CHOOSE
By
Bill Lantz
2013/06/19
|
Category:
choose
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,030 reads
What would the following return?
create table #Employee
(
PositionId int,
Birthday datetime
)
insert into #Employee
select 0, '1995-01-01'
union all
select 1, '1983-08-01'
union all
select 2, '1948-07-31'
union all
select 3, '1932-02-29'
union all
select 4, '1980-06-15'
--Query 1
SELECT BirthMonth = CHOOSE(Month(Birthday), 'January', 'February',...
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
Oleg Kryzhanovsky
939
1007
Ten Centuries
2.
GilaMonster
428
38099
SSChampion
3.
Sean Lange
413
8980
SSCrazy Eights
4.
Aadhar Joshi
362
1453
Ten Centuries
5.
chihaia_ciprian
326
1079
Ten Centuries
Show more
Latest forum posts
Lock Escalation Limit
By
Lokesh Vij
|
Jun 19, 2013
Posted to
Discuss content posted by Sourav Mukherjee
Why SQLCMD?
By
Shadab Shah
|
Jun 19, 2013
Posted to
SQL Server 2008 Administration
compare all tables and find number of common columns between...
By
sqlsean
|
Jun 19, 2013
Posted to
T-SQL (SS2K8)
Cause of Database Mirroring automatic failover
By
SQL Show
|
Jun 19, 2013
Posted to
SQL Server 2008 High Availability
How you take the breakup by each component in Multi_Pages ( ...
By
SQL Show
|
Jun 19, 2013
Posted to
SQL Server 2008 - General
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
