|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
More PowerShell Variables | |
I have this code:
$name = 'Steve' write-host( 'My name is $name')What is returned? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Kendra Little) |
Fashion What kind of shirts does Steve Jones like to wear? Answer: Hawaiian Explanation: |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2016 - Administration |
TDE for Always on databases - Hi All, In terms configuring and usage of TDE encryption is there a difference for Standalone instance databases & databases involved in AG? Because the secondary will be in read-only, just want to know how to configure TDE on AG databases and during failover do we need to take care of any additional steps etc.. […] |
Parameter Sniffing - Hi All, I know there are various causes for parameter sniffing issues, but one I want to focus on is: not having a covering index. Logically speaking then, having a covering index would be a way to address the issue. This is further evidenced in Tara Kizer's comment on: https://www.brentozar.com/archive/2018/03/troubleshooting-parameter-sniffing-issues-the-right-way-part-1/ There’s lots of ways to […] |
script out the dbmail settings and profiles - How can we take the script of existing db mail settings and profiles ? |
Administration - SQL Server 2014 |
Problem with KB4532095 installation - Has anyone else had trouble installing this security patch? It starts up and I get to the screen where I have to select my instances and it won't select anything... my instance is running and I can connect to it. But the update patch won't let me select anything on this screen. Any thoughts on […] |
SQL Server 2012 - T-SQL |
update query is running very slow - HI All, I am new to sql tuning. I have this below update statement which is taking more than an 1 hour. Why it is taking long time or is there a way to speed things up? UPDATE [dbo].[Test_tbl] set SQL_DETAIL='SELECT ROWID_OBJECT, HUB_STATE_IND, MDM_ID, SEQ_NM, MSP_END_CUST_NM, SEQ_TYP_CD, OST_NM, ALIAS_NM, STATUS_CD, DUNS_NMBR, C3_DUNS, BO_CLASS_CODE, C6, C6_NM2, […] |
SQL Server 2019 - Administration |
grant unmask to role - Hi All, i am using SQL Server Management Studio 2017. i have a database and i have masked a column. There are 500 users who are using the database. Upon request i need to provide unmask data to around 150 users. Would it be possible to create a database role and give the grant to […] |
Cannot connect to SQL Server, which is on VirtualBox, through my host computer - I have successfully pinged and telnet my virtualbox with my host computer but when I go to connect to the sql server with workbench I get the following error: 'Lost connection to MySQL server at 'waiting for initial communication packet', system error: 60'. Have tried everything it seems like and cannot seem to fix the […] |
SQL Replication - Uncooperative Databases - I have a database from a vendor which I need to mirror. This database, as a product, has tables which are dropped and recreated, truncated regularly, etc. Many issues which prevent a replication from being set up as I normally have. I very much wanted to have a transactional replication of this database as a […] |
T-SQL (SS2K8) |
Transposing the data and then converting monthly data to daily data - I have a Budget Table in following format Account -- Year -- Month1- Month2- Month3- Month4- Month5- Month6- Month7- Month8- Month9- Month10- Month11- Month12 500100 - 2020 - 100 - 200 - 300- 300- 300- 300- 300- 300- 300- 300- 300- 300 I would like to convert the data like below Account Period Amount 500100 […] |
SQL Server 2008 High Availability |
What's the requirement to have a witness server added? - I have a database which is configure with High safety without failover operating mode for it's mirroring. Now I would want to add a witness to this mirroring to allow it to perform automatic failover. May I know what is the requirement for the witness server? Does this server need to have a sql server […] |
SQL Azure - Development |
FileStream - Azure managed instance - Hi, Simple question, I know that FileStream is not supported in Azure DB single database or Elastic pools but is it supported in a managed instance? I've tried to find a definitive answer but I'm getting conflicting info. https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server?view=sql-server-ver15 Says it only applies to SQL Server (Windows Only) and not Azure SQL Database But https://serverfault.com/questions/901892/migrating-filestream-database-to-azure […] |
Amazon AWS and other cloud vendors |
Amazon RDS linked server issue - I have an RDS issue with a linked server (I know its not good, but I've inherited it) I keep loosing my linked server and we get the error "an error occurred during encryption" according to my google assistant and a few hours research every time... this occurs when Amazon switch us onto new hardware […] |
Integration Services |
OLE DB Destination has written 0 rows - Hi SSC, I'm having issues with one SSIS Package running on SQL Server 2017. What it does is basically: Truncate Table DFT OLE DB Source -> no Transformations or something -> OLE DB Destination When I run the Source Statement wether it's as a source preview or SQL Statement it works as expected. When I […] |
Hardware |
Search for wicked fast direct attach storage - After working and managing many different SAN's ( i am not going to name them but you can guess, these are top 5 ) i am sick and tired of dealing with networking changes and having army of people lined up to add a shelf. I was super happy with FIO direct attached storage, scaling […] |
Disaster Recovery |
Clustering - WSFC vs AGs - Hi, More and more I'm having discussions with customers who want to move away from FCI to AGs. The main reasoning is that AGs offer "faster, almost instant" failover times. I will admit I've never delved in to this difference, so I am asking here. What are the under-the-hood pros and cons of each; there […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |