It is the punctuation, the strange dollar signs, brackets and parentheses that bewilder anyone learning PowerShell. Add to that the aliases and you can bewilder everyone. The punctuation is essential, so here is the the complete PowerShell wallchart and guide to Powershell Punctuation. Thanks to Michael Sorens, PowerShell need no longer be perplexing.
2015-10-26
3,688 reads
It is important for developers and DBAs to be able to determine the interdependencies of any database object. Perhaps you need to work out what process is accessing that view you want to alter, or maybe find out whether that table-type you wish to change is being used. What are all these dependencies? How do you work out which are relevant? Phil Factor explains.
2015-10-23
3,238 reads
Oracle offers a results cache in the database (from 11.2 onwards) and in PL/SQL (again, from 11.2 onwards) which can greatly reduce execution time of repeated statements when insert/update/delete activity is not heavy. The mechanism in PL/SQL, however, may not work as expected with global temporary tables. Using a slightly modified example, Jonathan Lewis looks at what you might see when using this option.
2015-10-22
4,120 reads
If you're on SQL Server 2012 or greater, you definitely want to become familiar with all of the extensions to the windowing functions first introduced in SQL Server 2005 – they may give you some pretty serious performance boosts when revisiting code that is still running "the old way." Aaron Bertrand explains.
2015-10-21
4,230 reads
SQLXML isn't exactly new technology, and parts of it aren't pretty, but if you need to heave vast quantities of XML data into a SQL Server database then you may come to appreciate the raw speed of which it's capable. Adam Aspin shows how to configure the SQL XML Bulk Loader tool for optimal data loading performance.
2015-10-20
2,973 reads
This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.
2015-10-19
4,120 reads
SSC's Steve Jones will show you how Redgate's DLM solution works to improve your database development and deployment processes. You'll see how to version control your databases from SSMS to track and understand changes, include your database in your Continuous Integration process to get quick feedback, automate your database deployment process to have safe, reliable, repeatable deployments, and more.
2015-10-19 (first published: 2015-10-15)
4,162 reads
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
2015-10-16
2,930 reads
At the time of writing, SQL Server 2016 preview (CTP 2.3) has been released and there are some changes for the Integration Services (SSIS) Catalog logging levels.
2015-10-15
3,310 reads
One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).
2015-10-14
3,552 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Comments posted to this topic are about the item There's Too Much to Learn
Comments posted to this topic are about the item How to Calculate Distance Between...
Comments posted to this topic are about the item SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers