SQLServerCentral » Latest topics
An Introduction to PowerShell for a DBA
Comments posted to this topic are about the item [B]An Introduction to PowerShell for a DBA[/B]
Sunday, December 31, 2017
Saturday, December 30, 2017
using araylist in stored proc
SQLServerCentral » Latest topics
using araylist in stored proc
hello i have this stored proc for dynamically insert update delete select and select with id
but hier have a 2 column name and 2 values for this crud operaion
may be more columns and more values for crud opertaion
can i use ar
but hier have a 2 column name and 2 values for this crud operaion
may be more columns and more values for crud opertaion
can i use ar
Friday, December 29, 2017
Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
SQLServerCentral.com Articles
Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
Fantasy Football 2017
SQLServerCentral » Latest topics
Fantasy Football 2017
Placeholder for the 2017 league. Congrats to the 2016 winners:
Ray K - $100
SequelSurfer - $75
Steve Jones - $50
I'll do the same prizes next year. Everyone from 2016 has first crack at the league (12 teams), but if you're interested in joining, l
Thursday, December 28, 2017
Generate Create Login script for an Azure Logical SQL Server for DR purposes
SQLServerCentral » Latest topics
Generate Create Login script for an Azure Logical SQL Server for DR purposes
Hello,
I've done a fair bit of looking around, and I am not finding a way to generate a script that I can keep to recreate Azure SQL Server Logins (not users I've done that). I need something similar to the old sp_help_rev_login, but for Azure in
I've done a fair bit of looking around, and I am not finding a way to generate a script that I can keep to recreate Azure SQL Server Logins (not users I've done that). I need something similar to the old sp_help_rev_login, but for Azure in
Understanding Migration from SQL Server to SQL Server 2017 using Data Migration Assistant
SQLServerCentral.com Articles
Understanding Migration from SQL Server to SQL Server 2017 using Data Migration Assistant
You can use the Data Migration Assistant (DMA) tool to migrate your SQL Server instance to an on-premise SQL Server 2017 or to Azure SQL Database. DMA analyzes data migration issues and provides recommendations to resolve them. Read on learn about the features of DMA and how DMA eases your SQL Server instance migration as well as reduces overall risks, allowing you to complete the migration successfully.
Splitting TempDB across multiple files
SQLServerCentral » Latest topics
Splitting TempDB across multiple files
I have a question regarding the splitting of TempDB in SQL Server, I know its a must in production environments as DBs Start growing and system becomes move complex.
In terms of a System Test / UAT environments, Should the exact sam
Wednesday, December 27, 2017
Redgate data governance survey reveals database DevOps is the key to GDPR compliance
SQLServerCentral.com Articles
Redgate data governance survey reveals database DevOps is the key to GDPR compliance
A major new data governance survey from Redgate demonstrates there are important GDPR compliance issues that need to be addressed – and that a DevOps approach to database development can provide the answers.
Two tables, exact same structure but with different names, behave differently while performing mass updates.
SQLServerCentral » Latest topics
Two tables, exact same structure but with different names, behave differently while performing mass updates.
Hi all,
This has me stumped. I'm performing mass updates to a table. I'm using Data Masker by Redgate to de-identify the data. It's basically a wide update, involving 8+ columns. The table has around 662K+ rows. I have the constraints disab
This has me stumped. I'm performing mass updates to a table. I'm using Data Masker by Redgate to de-identify the data. It's basically a wide update, involving 8+ columns. The table has around 662K+ rows. I have the constraints disab
Tuesday, December 26, 2017
Rethink Server Sizing
SQLblog.com - The SQL Server blog spot on the web
Rethink Server Sizing
Standardizing on 2 and 4 sockets systems for servers has been an established practice going back to 1996. There were very good reasons for this, but it was so long ago that they have been forgotten. Yet the practice continues unquestioned, almost as a reflex action ingrained in our subconscious. Back then, 2-way was the baseline, and a 4-way was for databases. Now, the large majority of standard systems are 2-way (2S) with 4S for exceptional requirements. It might seem that the 2-socket system continues...(read more)
Subscribe to:
Posts (Atom)