2016-05-11
4,469 reads
Additional Articles
SQL Server Security Audit Basics
SQL Server Server Audit has grown in functionality over the years but it can be tricky to maintain and use because it lacks centralization and analysis tools. It can do a fast and lightweight audit of many different activities including DML and DDL at both Instance and Database Levels - even the work of the DBAs. How do you check logins and permissions? How do you script an enterprise-wide audit solution? How can you hope to analyse the log data you get? Feodor Georgiev gets you started.
2016-05-10
3,537 reads
Big Data Architecture
The next few years will be critical for the information technology staff, as they attempt to integrate and manage multiple, diverse hardware and software platforms. In this article, Lockwood Lyon addresses how to meet this need, as users demand greater ability to analyze ever-growing mountains of data, and IT attempts to keep costs down.
2016-05-09
5,553 reads
SQL Server Reporting Services CountDistinct and Previous Functions
Scott Murray takes a look at what count function variations and related functions are available in SQL Server Reporting Services (SSRS).
2016-05-06
3,345 reads
ASP.NET Core: A More Realistic Starter Kit
ASP.NET Core is a fascinating platform with many good ideas, but in its present form (RC1)there is a culture shock for experienced ASP.NET developers to experience the effort involved in porting a realistic application. There is an obvious advantage on being able to host an application on any web server, but is this enough to compensate for losing the convenience of an integrated pipeline?
2016-05-05
3,586 reads
STRING_SPLIT() in SQL Server 2016 : Follow-Up #1
Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.
2016-05-04
3,767 reads
Execute Dynamic SQL commands in SQL Server
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?
2016-05-03
5,701 reads
Getting started with Azure SQL Data Warehouse
Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.
2016-05-02
3,466 reads
Questions About PowerShell Basics That You Were Too Shy To Ask
Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.
2016-04-29
4,782 reads
Azure SQL Database Elastic Database Jobs
In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.
2016-04-28
5,096 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Making an Impression
Comments posted to this topic are about the item Making an Impression
SQL Server Vector Support I
Comments posted to this topic are about the item SQL Server Vector Support I
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers