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.
I’ve been doing storage load tests for SQL Server for a long time, both...
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
I have an app that has an address field on the customer and the...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers