(Michelle Ufford) This is the first in a new series focused on PowerShell for SQL developers. That means using PowerShell to create and/or modify table schema, stored procedures, and indexes.
Tag: sql server
SQL Server 2012 Integration Services – Using PowerShell to Configure Project Environments
(Marcin Policht) In the recent articles published on this forum, we have been discussing how to leverage the capabilities of PowerShell to automate the most common SQL Server Integration Services administrative task, focusing in particular on the project deployment model introduced in SQL Server 201
DirectQuery Mode in SQL Server 2012 Analysis Services (SSAS) Tabular
(Ray Barley) I am building a SQL Server 2012 Analysis Services Tabular model to support ad-hoc queries for a particular department within my organization. One of the requirements is that the database must always provide the most up-to-date data at all times.
Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 3
Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 3 In this, the third of a three-part article focusing upon the PeriodsToDate() and OpeningPeriod() time series functions, we will continue to expose functions that we can use to perform analysis within the context of time. As we discussed in Part 1, many business requirements revolve around theperformance of analysis...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Migrating SQL Server Databases – The DBA’s Checklist (Part 2)
(Sadequl Hussain) It is always a good idea to update the statistics of the database that you have just installed or migrated. To do this, run the following command against the target database:
The many uses of CROSS APPLY
(Kenneth Fisher) Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
The DBA Detective: The Case of the Missing Index
(Grant Fritchey) When problems arise in SQL Server, we’re faced with a server full of suspects, including disk I/O, memory, CPU, incorrect or missing indexes, badly written T-SQL code, out of date statistics, and full disk drives. All of these have motive and opportunity to murder the performance of
How to prevent SQL Injection in Stored Procedures
(Wong Shao Voon) Some database programmers believe that by using stored procedures, their code are safe from SQL injection attacks. That is not entirely true if dynamic query is used inside the stored procedures and the dynamic query is constructed by concatenating the parameters. In circumstances,
Rolling up multiple rows into a single row and column for SQL Server data
(Douglas P. Castilho) I need a way to roll-up multiple rows into one row and one column. I know I can roll-up multiple rows into one row using Pivot, but I need all of the data concatenated into a single column in a single row. In this tip we look at a simple approach to accomplish this.
Setting up SQL Agent in SQL Server to run ETL Jobs
(biscoop) By Default SQL Agent is Disabled on SQL Server, and if you need to use the SQL Agent then you need to execute the following :-