Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
<< Newer
Items 41 to 60 of 16728
Older >>
How to Programmatically Identify When Your SQL Server Was Last Started
Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.
Read more...
By
Additional Articles
2018/04/10
|
Source:
Database Journal
|
Category:
administration
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,146 reads
What's Downtime?
Steve asks the question today of how you might measure downtime and the scope you are concerned about.
Read more...
By
Steve Jones
2018/04/09
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
40 reads
Stumbling over Words
Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.
Read more...
By
Phil Factor
2018/04/09
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
|
Discuss
|
Briefcase
|
74 reads
Avoiding Unexpected Results with DATEDIFF in Year Comparisons
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
Read more...
By
David Strack
2018/04/09
|
Source:
SQLServerCentral.com
|
Category:
sql server
Rating:
|
Discuss
|
Briefcase
|
1,269 reads
Mount SQL Server DMVs and Custom Queries Using DBFS on Linux
With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.
Read more...
By
Additional Articles
2018/04/09
|
Source:
SimpleTalk
|
Category:
sql server on linux
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,235 reads
How to execute a Powershell script via SSIS
Learn how you can execute a PowerShell script via the SSIS execute process task.
Read more...
By
Perry Whittle
2018/04/06 (first published: 2015/12/03)
|
Source:
SQLServerCentral.com
|
Category:
execute process task
Rating:
|
Discuss
|
Briefcase
|
5,652 reads
One Size Does Not Fit All
Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.
Read more...
By
Derik Hammer
2018/04/06
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
152 reads
Data Retention: An Inexact Art
A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the principles, but gives good advice -- leave the details to the specialists.
Read more...
By
Additional Articles
2018/04/06
|
Source:
SimpleTalk
|
Category:
data retention
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,776 reads
Scripting Tables and Procedures from SSMS
Learn how you can script specific objects from SSMS and store or update them in a git repository.
Read more...
By
Steve Jones
2018/04/05
|
Source:
SQLServerCentral.com
|
Category:
management studio (ssms)
Rating:
|
Discuss
|
Briefcase
|
1,038 reads
Analyze entity data flow in Power BI Desktop using Sankey charts
Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop.
Read more...
By
Additional Articles
2018/04/05
|
Source:
MSSQLTips.com
|
Category:
power bi desktop
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,885 reads
In Memory of Robert
In memory of Robert Davis.
Read more...
By
Steve Jones
2018/04/05
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
|
Discuss
|
Briefcase
|
94 reads
Is the DBA Title Dying?
Titles are very important to many people. Steve wonders if the main title many of us use will go away.
Read more...
By
Steve Jones
2018/04/04
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
125 reads
Stairway to Biml Level 4: Using Biml as an SSIS Design Patterns Engine
In this level, we make a large leap forward, showing you how to use BIML to script a large number of packages using C#.
Read more...
By
Andy Leonard
2018/04/04 (first published: 2013/08/14)
|
Source:
SQLServerCentral.com
|
Category:
biml
Rating:
|
Discuss
|
Briefcase
|
13,011 reads
Free eBook: Inside the SQL Server Query Optimizer
This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.
Read more...
By
Press Release
2018/04/04 (first published: 2012/12/11)
|
Source:
SQLServerCentral.com
|
Category:
books
Rating:
Rate this
|
Briefcase
|
42,328 reads
Controlling Access to Azure Cosmos DB
Azure Cosmos DB offers features that facilitate data availability and resiliency. However, there is also a different, very important aspect of facilitating access to distributed data sources in the most optimal manner, which focuses on access control mechanisms. Read on to learn the specifics of this aspect, as it applies to Azure Cosmos DB.
Read more...
By
Additional Articles
2018/04/04
|
Source:
Database Journal
|
Category:
azure cosmos db
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,847 reads
ETL or ELT
What pattern is better for importing data? Steve discusses.
Read more...
By
Steve Jones
2018/04/03
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
|
Discuss
|
Briefcase
|
92 reads
Cache Snapshots And History Snapshots in SSRS 2016
The various Snapshot options in Reporting Services 2016 explained.
Read more...
By
Suresh Kumar
2018/04/03
|
Source:
SQLServerCentral.com
|
Category:
ssrs 2016
Rating:
|
Discuss
|
Briefcase
|
401 reads
An Easier Way of Transposing Query Result in SQL Server
T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT statement, but it doesn’t quite accomplish the task. In this article, Darko Martinovic shares another method using a SQLCLR stored prodedure.
Read more...
By
Additional Articles
2018/04/03
|
Source:
SimpleTalk
|
Category:
sqlclr
Rating:
(not yet rated)
Rate this
|
Briefcase
|
4,761 reads
Take the SQL Estate Data Mapping Survey and help shape Redgate’s products
Help Redgate to learn more about how SQL Server teams keep on top of sensitive data. If you're planning, or are already implementing, an information audit or data-mapping exercise for your SQL Server estate, please complete their short survey.
Read more...
By
2018/04/03
|
Source:
Redgate
|
Category:
survey
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,161 reads
Paying It Forward
Today we have a guest editorial from Andy Galbraith that looks at the ways in which he has helped others in his career.
Read more...
By
Andy Galbraith
2018/04/02
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
|
Discuss
|
Briefcase
|
222 reads
<< Newer
Items 41 to 60 of 16728
Older >>
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.