An Interview with Allen Kinsel, PASS Board Candidate
Allen Kinsel is running for the board of directors of PASS. He took a little time to answer some questions from Steve Jones
2013-09-27
446 reads
Articles
Extended Properties Introduction
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
24,021 reads
Generating Random Numbers in SQL Server Without Collisions
From time to time, I see a requirement to generate random identifiers for things like users or orders. People want to use random numbers so that the "next" identifier is not guessable, or to prevent insight into how many new users or orders are being generated in a given time frame, but they don't want to run into any duplicates. We can trade a bit of disk space and relatively predictable (but not optimal) performance for the guarantee of no collisions, no matter how many random numbers we've already used.
2013-09-27
3,852 reads
Red Gate will be exhibiting at SQL Server Live! Orlando
SQL Server Live! is coming to Orlando November 18-22. SQL Server Live! provides comprehensive education and knowledge share on SQL Server database management, data warehouse/BI model design, performance tuning, troubleshooting and more.
2013-09-26
378 reads
A Practical Guide to Microsoft Hyper-V Replica: Part II
A Hyper-V replica installation provides rapid disaster-recovery by asynchronously replicating a VM running at a primary site to a replica site. Know how to prepare for something to go wrong at the Primary Server/Site? In this article Nirmal Sharma presents the Replication options for a Replica Virtual Machine with a focus on Hyper-V Failover.
2013-09-26
3,293 reads
SSIS 2012 - Introduction to Windows Azure SQL Databases
When discussing SQL Server 2012 Integration Services, we have been dealing mainly with the traditional data management model, where the entire SQL Server environment resides on-premise. This once predominant paradigm is obviously changing, with hosted solutions (in the form of both private and public clouds) becoming increasingly common. In order to properly account for this trend, we turn our attention to the role that SSIS can serve in a mixed environment, where a part of the SQL Server estate is located in Windows Azure.
2013-09-25
2,973 reads
Manage SQL Server Reporting Services in Management Studio
Most maintenance for SSRS is performed either in Report Manager online or within the Report Services Configuration Manager from the desktop. The SSRS Management Studio connection is certainly no replacement for either of these tools, however, several benefits can be obtained using SSMS. First, you are able to connect to the SSRS even if you are having browser issues; second, it is often quicker to just switch from using Management Studio for the Database Engine.
2013-09-24
4,676 reads
SQL Server Cloud Migration Part I
A SQL Server migration with minimal business impact while synchronizing schema and data.
2013-09-23
3,377 reads
The PoSh DBA – Getting to know PowerShell
Although it was primarily designed for System Administrators, PowerShell is now extending its use to Database, SharePoint, Exchange and all Microsoft products. In this article Laerte Junior offers an introduction to PowerShell and describes how DBAs can use PowerShell to automate repetitive tasks. He also explains when to use PowerShell instead of, or in addition to, T-SQL and SSIS.
2013-09-23
3,686 reads
SQL Server Reporting Services Report Manager Tips and Tricks
Dattatrey Sindol shares his tips and tricks on SQL Server Reporting Services Report Manager. He provides guidance on Customizing Report Manager Header/Title, Uploading Custom File Types to Report Manager, and Enable My Reports Feature.
2013-09-20
5,922 reads
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