Free BI Training in June
Free training from Pragmatic Works, Microsoft and SQLServerCentral. Learn about SSAS performance, SSIS Configurations, GIS in SSRS and more.
SQL Server 2008 and 2008 R2 Integration Services - Message Queuing Using Script Task
SQL Server 2008 R2 Integration Services offer a number of built-in features that simplify ETL, but they come with limited functionality. Here's a solution.
The SQL Server BI Quiz
From MVP Jacob Sebastian, creator of the T-SQL Challenges, there is a BI quiz throughout the month of June. Enter and answer questions each day for the chance to win prizes.
Red Gate extends freedom of mobile SQL monitoring
Red Gate has released SQL Monitor 2.3, providing improved data analysis and the ability to receive alerts through PagerDuty.
The Care of Data
Security is a big concern with data, especially when there is another company involved. Steve Jones notes today that cloud vendors need to beef up their work in this area.
Determine SQL Server memory use by database and object
For many people, the way that SQL Server uses memory can be a bit of an enigma. A large percentage of the memory your SQL Server instance utilizes is consumed by buffer pool (essentially, data). Without a lot of digging, it can be hard to tell which of your databases consume the most buffer pool memory, and even more so, which objects within those databases. This information can be quite useful, for example, if you are considering an application change to split your database across multiple servers, or trying to identify databases that are candidates for consolidation.
Raw Materials - The Vermillion Screen of Death
An elementary error foils Peter's plans for world domination.
The Ad Hoc Change
Almost every DBA will be asked to change data in production at some point. Too often we don't have the tools to allow users to correct errors, but when you make changes, Steve Jones reminds you that you need to be careful and still have a process.
Using Extended Events to troubleshoot SQL Server issues
As a DBA, you'll encounter elusive performance, connectivity and locking problems that you'll need to troubleshoot. There are many tools that you can use such as Profiler. In addition to these tools, SQL Server 2008 offers extended events ("XEvents"), which you can use as a powerful tracing system. By default, the "system_health" extended events session is always on, and can provide you help to locate the source of trouble much faster.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Berikut cara menutup kartu kredit UOB sampai tuntas
Untuk menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp (6288220114008): atau...
Ini tata cara mudah menutup - menonaktifkan kartu kredit UOB
Untuk menonaktifkan dan menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers