Pinboard RSS Feed for SQL
- SQL SERVER – An Efficiency Tool to Compare and Synchronize SQL Server Databases | Journey to SQL Authority with Pinal Dave
SQL SERVER – An Efficiency Tool to Compare and Synchronize SQL Server Databases, from Journey to SQL Authority with Pinal Dave http://blog.sqlauthority.com - SQL SERVER – List of All the Samples Database Available to Download for FREE | Journey to SQL Authority with Pinal Dave
SQL SERVER – List of All the Samples Database Available to Download for FREE, from Journey to SQL Authority with Pinal Dave http://blog.sqlauthority.com - Security Questions: Migrate Logins Between Servers | Strate SQL
Security Questions: Migrate Logins Between Servers, from Strate SQLStrate SQL http://www.jasonstrate.com - Security Questions: SQL Agent Permissions | Strate SQL
Security Questions: SQL Agent Permissions, from Strate SQLStrate SQL http://www.jasonstrate.com - SSIS Junkie : Want to prove something with data? Aggregate it!
Want to prove something with data? Aggregate it!, from SQLblog.com – The SQL Server blog spot on the web http://sqlblog.com/blogs/default.aspx - Kalen Delaney : Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper
Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper, from SQLblog.com – The SQL Server blog spot on the web http://sqlblog.com/blogs/default.aspx - Security Questions: TRUNCATE TABLE Permissions | Strate SQL
Security Questions: TRUNCATE TABLE Permissions, from Strate SQLStrate SQL http://www.jasonstrate.com - Security Questions: Authentication Performance | Strate SQL
Security Questions: Authentication Performance, from Strate SQLStrate SQL http://www.jasonstrate.com - Security Questions: Difference between sysadmin and CONTROL SERVER Permission | Strate SQL
Security Questions: Difference between sysadmin and CONTROL SERVER Permission, from Strate SQLStrate SQL http://www.jasonstrate.com - SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods | Journey to SQL Authority with Pinal Dave
SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods, from Journey to SQL Authority with Pinal Dave http://blog.sqlauthority.com - Blogging Best Practices – Checklist for Building Successful Blog – Part 6 | Journey to SQL Authority with Pinal Dave
Blogging Best Practices – Checklist for Building Successful Blog – Part 6, from Journey to SQL Authority with Pinal Dave http://blog.sqlauthority.com - Blogging Best Practices – Frequently Asked Questions – Part 5 | Journey to SQL Authority with Pinal Dave
Blogging Best Practices – Frequently Asked Questions – Part 5, from Journey to SQL Authority with Pinal Dave http://blog.sqlauthority.com - The Optimizer Isn’t As Smart As You Might Want It To Be – SQL Server with Mr. Denny
The Optimizer Isn’t As Smart As You Might Want It To Be, from SQL Server with Mr. Denny http://itknowledgeexchange.techtarget.com/sql-server - Blogging Best Practices – Writing an Interesting Blog – Part 3 | Journey to SQL Authority with Pinal Dave
Blogging Best Practices – Writing an Interesting Blog – Part 3, from Journey to SQL Authority with Pinal Dave http://blog.sqlauthority.com - SQL SERVER – Get High Availability with SQL Server 2012 | SQL Server Journey with SQL Authority
SQL SERVER – Get High Availability with SQL Server 2012, from SQL Server Journey with SQL Authority http://blog.sqlauthority.com - SQL SERVER – Beginning SQL 2012 – Why we use Code Comments – Abstract from Joes 2 Pros Volume 1 | SQL Server Journey with SQL Authority
SQL SERVER – Beginning SQL 2012 – Why we use Code Comments – Abstract from Joes 2 Pros Volume 1, from SQL Server Journey with SQL Authority http://blog.sqlauthority.com - John Paul Cook : SQL Server 2012–what it is and what it isn’t
SQL Server 2012–what it is and what it isn’t, from SQLblog.com – The SQL Server blog spot on the web http://sqlblog.com/blogs/default.aspx - The Bit Bucket (Greg Low): IDisposable : Improvements in the Red Gate source code control suite
Improvements in the Red Gate source code control suite, from SQLblog.com – The SQL Server blog spot on the web http://sqlblog.com/blogs/default.aspx - SQL SERVER – T-SQL Script to Keep CPU Busy | SQL Server Journey with SQL Authority
SQL SERVER – T-SQL Script to Keep CPU Busy, from SQL Server Journey with SQL Authority http://blog.sqlauthority.com - SSIS Junkie : My first venture into Hadoop
My first venture into Hadoop, from SQLblog.com – The SQL Server blog spot on the web http://sqlblog.com/blogs/default.aspx - Mirrored databases are disconnected after you restart the database mirror in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2
Mirrored databases are disconnected after you restart the database mirror in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2, from Most Recent KBs for SQL Server 2008 R2 http://support.microso … - SQL Server support in a hyper-threaded environment
SQL Server support in a hyper-threaded environment, from Most Recent KBs for SQL Server 2008 R2 http://support.microsoft.com/ph/14917 - SQL SERVER – 2005 – List all the database « SQL Server Journey with SQL Authority
SQL SERVER – 2005 – List all the database May 12, 2007 by pinaldave List all the database on SQL Servers. All the following Stored Procedure list all the Databases on Server. I personally use EXEC sp_ … - SQL Server – Cannot attach a database that was being restored | James' Sandbox
This was a fun error. We had an extremely large database (450 GB) that was in the process of restoring and got hung up in SQL Server 2005. Each time we would try to attach the database, it would fail … - Do You Use Projects/Solutions in SSMS? – SQLServerCentral
When SQL Server 2005 was released Microsoft made a major change to the client tools provided with SQL Server, moving from Enterprise Manager for management tasks and Query Analyzer for scripting to th … - Why does change control for SQL Server have to be so hard? – SQLServerCentral
I’ve been dealing with change control and source code repositories for most of my professional career. While I’ve seen change control and integration advance steadily for writing programs it feels lik … - Memory for Multiple instances on a cluster?
This takes one table in master, two stored procedures, and one job that is set to execute on startup and calls the first stored procedure ([master].[dbo].[auto_MemoryReconfigure]). I set the default m … - Tom's blog » SQL Clustered Instances automatic Max Server Memory settings
In our environment we have several SQL clusters, most of them in an active-active configuration. Microsoft recommends that the sum of all maximum server memory for all instances is equal to the total … - SQL SERVER – Get All the Information of Database using sys.databases « SQL Server Journey with SQL Authority
Earlier I wrote blog article SQL SERVER – Finding Last Backup Time for All Database. In the response of this article I have received very interesting script from SQL Server Expert Matteo as a comment … - SQL Server 2008 R2 – Unattended Silent Install – CodeProject
There is existing documentation on MSDN about How to: Install SQL Server 2008 R2 from the Command Prompt, but this post focuses on creating a silent unattended install of SQL Server 2008 R2 (Standard … - Need Script to run unattend SQL Image completion in 2008 R2
Here is a blog post which gives you all necessary information about unattended SQL installations: http://blogs.msdn.com/b/mwilmot/archive/2007/12/28/sql-server-unattended-install-script.aspx And start … - Standardize SQL Server Installations with Configuration Files
If you have a requirement to install multiple SQL Server instances with the same settings, you most likely want to do it without following the numerous manual installation steps. The below tip will gu … - Considerations for Installing SQL Server Using SysPrep
Stand-alone installation of SQL Server includes two actions: prepare and complete. In SQL Server 2008, these two actions are run as one integrated step during the installation process. Starting with S … - Instance Configuration
Use the Instance Configuration page of the SQL Server Installation Wizard to specify whether to create a default instance or a named instance of SQL Server. If an instance of SQL Server is not already … - How to: Install SQL Server 2008 R2 Using SysPrep
SQL Server SysPrep related setup actions can be accessed through the Installation Center. The Advanced Page of the Installation Center has two options – Image preparation of a stand-alone instance for … - Considerations for Installing SQL Server Using SysPrep
SQL Server Sysprep allows you to prepare a stand-alone instance of SQL Server on a computer and to complete the configuration at a later time. SQL Server Sysprep involves a two-step process to get to … - Understanding the SQL Server NOLOCK hint
I see the use of the NOLOCK hint in existing code for my stored procedures and I am not exactly sure if this is helpful or not. It seems like this has been a practice that was put in place and now is … - How to Rename SQL Server – Cindy Gross – SQL Server and Big Data Troubleshooting + Tips – Site Home – MSDN Blogs
How to rename a SQL Server varies a bit depending on the SQL version, whether it is clustered or not, and whether you want to rename the server/virtual server part of the name (works except for SQL 20 … - What SPN do I use and how does it get there? – CSS SQL Server Engineers – Site Home – MSDN Blogs
This month has turned into another Kerberos Month for me. I had an email discussion regarding SPN’s for SQL Server and what we can do to get them created and in a usable state. I thought I would sha … - PowerShell Week at SQL University Post 4 – Profiles, Modules, Snapins | SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V
So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what providers are and how to work … - The PoSh DBA: Grown-Up PowerShell Functions
Laerte goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing how pipelines and advanced functions can make PowerShell more e … - SQL 2012 and Powershell for the Bleeding Edge DBA
Overview of Powershell 3 tools and features and SQL 2012 Cmdlets and SMO. From recent presentation for SFSSUG.com - Resolving could not open a connection to SQL Server errors
These errors could be for either Named Pipes connections or TCP/IP connections. In this tip, we look at what may be causes to these errors and how to resolve. - SQL Tip: Union vs. Union All Query Syntax for SQL Server and Microsoft Access
The purpose of the SQL UNION and UNION ALL commands are to combine the results of two or more queries into a single result set consisting of all the rows belonging to all the queries in the union. The … - The Rambling DBA: Jonathan Kehayias : Finding Implicit Column Conversions in the Plan Cache
Last year Tibor Karaszi posted a blog post titled Match Those Types that talked about implicit data type conversions associated with mismatched data types between filter criteria and table column data … - Error message when you try to save a table in SQL Server: "Saving changes is not permitted"
This problem occurs when the Prevent saving changes that require the table re-creation option is enabled, and you make one or more of the following changes to the table: You change the Allow Nulls set … - Copy-Only Backups (SQL Server)
A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. Usually, taking a backup changes the database and affects how later backups are restor … - Loading SQL Server Snapins into your PowerShell Session – Dan's Blog – Site Home – MSDN Blogs
SQLPS.exe is a decent environment, but sometimes I want to work in the default PowerShell environment. But if I want to work with SQL Server in the default PowerShell shell it means I need to load the … - Practical PowerShell for SQL Server Developers and DBAs – Part 1
There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael expla … - Making A SQLPS Module | Sev17
If you’re working with PowerShell and SQL Server one of things you’ll want to to do is load the SQL Server 2008 provider and cmdlets into a regular PowerShell. Michiel Wories, the creator of SMO and s …
