SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Import AdventureWorks2012_Database.zip to SQL Server 2016

  Hello team,Is it possible to import AdventureWorks2012_Database.zip to SQL Server 2016?

  flash_os

  13 replies

  9 years ago

  By: flash_os

• PBE security and possible information disclosure

  Has anyone looked into the security aspects of the Buffer Pool Extension? My concern is that o…

  Eirikur Eiriksson

  1 replies

  9 years ago

  By: sgmunson

• restore 2012 Enterprise onto 2012 Standard

  hello, we have a 2012 SP1 Ent server with no partitioning currently configured. We also have a 2016…

  samuel.bartick

  3 replies

  9 years ago

  By: samuel.bartick

• Database Architecture Question

  Hi, I know there's always 100 different ways to skin a cat, so I thought I'd see what you recommend…

  Mike Scalise

  15 replies

  9 years ago

  By: EdVassie

• In place upgrade from SSRS 2012 BI edition to SQL 2016

  Hi,We have 3 SSRS report servers in our estate, one for DEV, one for UAT and one for PROD.Both DEV …

  NicHopper

  1 replies

  9 years ago

  By: NicHopper

• SQL Server 2016 DBA Training

  Hi people, I've been working as a SQL developer for a number of years, with an increasing amount of…

  Andy Reilly

  20 replies

  9 years ago

  By: SQLRNNR

• sys.dm_db_index_usage_stats -- what about tables w/ NO INDEXES defined?

  To identify "table usage" on a given SQL Server, I've read up on several articles mentioning the us…

  Express12

  1 replies

  9 years ago

  By: Gail Shaw

• Advise on AlwaysOn new feature - direct seeding

  Hi Guys,Seeking advise. 1. Once AG is setup with automatic seeding, whenever i create a database in…

  chewychewy

  2 replies

  9 years ago

  By: Beatrix Kiddo

• Issues on 2014 to 2016 upgrade.

  Hi, I have a cluster with differents SQL version (2012-2014) and i need to update an instance to SQ…

  fabien.lopes

  6 replies

  9 years ago

  By: Phil Parkin

• 2016 Cluster Questions For Always On but also with other services

  I'm trying to build up my clustering skills in my Lab, which is an all virtualbox environment.I wan…

  BobbyTables

  13 replies

  9 years ago

  By: Perry Whittle

• tempdb data and log file

  Hi,We have some reporting queries which use tempdb very heavily and I get alerts from monitoring to…

  sqlguy80

  9 replies

  9 years ago

  By: Perry Whittle

• Windows Defender

  Hi, I was trying to figure out whether or not to keep Windows Defender turned on or off on our data…

  dajonx

  4 replies

  9 years ago

  By: Steve Jones - SSC Editor

• SQL Server Feature Pack for 2016, DB2 OLE DB Drivers

  Where can I find good documentation about the DB2 OLE DB version 5 driver? Is there a compatibility…

  mharding 65939

  2 replies

  9 years ago

  By: mharding 65939

• Restore 2008R2 DB w/ NORECOVERY

  Hi Guys, I have two questions. I just restored a full backup into norecovery from a SQL Server 2008…

  alex.sqldba

  3 replies

  9 years ago

  By: alex.sqldba

• Issues trying to set up linked server from SQL 2012 to SQL 2016

  Hello experts, I need to create a linked server from a SQL 2012 server to a SQL 2016 server and I a…

  webrunner

  1 replies

  9 years ago

  By: Mr. Brian Gale