While perusing some of the threads on SQLServerCentral.com one of the questions that hit me was regarding the use of scalar functions in queries. In this particular case, in the column list of a SELECT statement. Did it make sense to encapsulate a routine...
This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.
In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or most highly-regulated industries. SQL Server 2008 Enterprise Edition includes all of the features, whereas SQL Server 2008 Standard Edition only provides a subset. What is most attractive about it, is that it is easy to administer, as Thomas LaRock explains.
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
The problems with Windows 7 downloads were blamed on SQL Server. Steve Jones thinks this was a huge mistake.
Using an audit table to rollback changes to data might be a nice addition to many applications. David McKinney's new series looks at how you can use this data for RollBack or RollForward.
In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.
For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance.
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
Whatsapp: 083139530154 Jl. Raya Satelit Indah No. AN-2,Tanjungsari, Kec. Sukomanunggal, Kota SBY, Jawa Timur...
Bantuan resmi reschedule penerbangan Pelita Air anda bisa menghubungi layanan resmi di nomor tlp/wa...
WhatsApp: 0817825533, Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Ground Floor,...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers