<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,394 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
|
2,605 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
|
280 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
|
815 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,090 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
|
5,858 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,397 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,609 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,020 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,589 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,549 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,221 reads
Browse all
Question of the Day
SQL CHOOSE
By
Bill Lantz
2013/06/19
|
Category:
choose
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
875 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
996
1007
Ten Centuries
2.
GilaMonster
423
38086
SSChampion
3.
Aadhar Joshi
409
1453
Ten Centuries
4.
Sean Lange
408
8967
SSCrazy Eights
5.
chihaia_ciprian
326
1079
Ten Centuries
Show more
Latest forum posts
SQL Server Should Work for Us
By
Andy Leonard
|
Jun 19, 2013
Posted to
Editorials
how to copy for a file in sub directories basing on the file...
By
SQL_Learning
|
Jun 19, 2013
Posted to
SQL Server Newbies
SQL CHOOSE
By
SQLDCH
|
Jun 19, 2013
Posted to
Discuss content posted by Bill Lantz
Grouping Related Rows in Same Table
By
TheSQLGuru
|
Jun 19, 2013
Posted to
SQL Server 2012 - T-SQL
Alias Usage
By
KWymore
|
Jun 19, 2013
Posted to
Discuss content posted by Ismail ADAR
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
