Step By Step Logshipping configuration
Log shipping provides a means to maintain a secondary server on an automated basisusing a chain of transaction log backups. This chapter explains the basic confi guration oflog shipping...
2017-03-02
10 reads
Ganapathi's MSSQLLover
Everything on Always on Availability Groups series
Step By Step configuring Windows 2012 R2 fail over cluster How to setup windows cluster for Always on Availability Groups
AlwaysOn Availability...
2017-03-01
667 reads
Everything on Always on Availability Groups series
Step By Step configuring Windows 2012 R2 fail over cluster How to setup windows cluster for Always on Availability Groups
AlwaysOn Availability Groups: Step by Step Setup Step by Step procedure to...
2017-03-01
4 reads
Step By Step configring Windows 2012 R2 fail over cluster
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage...
2017-03-01
3,003 reads
Step By Step configring Windows 2012 R2 fail over cluster
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage to setup Always on availability. it can be configured...
2017-03-01
11 reads
Webinar- SQL Server 2016 - Always Encrypted / Security
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM
SQL Server has had ways to...
2017-02-23
655 reads
Webinar- SQL Server 2016 - Always Encrypted / Security
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PMSQL Server has had ways to encrypt data in the past - for...
2017-02-23
8 reads
AlwaysOn Availability Groups: Step by Step Setup
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail...
2017-02-20
78,173 reads
AlwaysOn Availability Groups: Step by Step Setup
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of...
2017-02-20
11 reads
vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
One of my client vCenter Server fails to start as below shown error in event logs.Could not allocate space for...
2017-02-17
649 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers