Contents tagged with sql server
-
Use Extended Events to Get More Information About failed SQL Server Login Attempts
https://www.mssqltips.com/sqlservertip/3214/use-extended-events-to-get-more-information-about-failed-sql-server-login-attempts/ more
-
SQL Server: Prepare a Mirror Database for Mirroring
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/prepare-a-mirror-database-for-mirroring-sql-server?view=sql-server-ver15 more
-
Backing Up SQL Server Databases is Easier in PowerShell than T-SQL
https://www.sqlservercentral.com/articles/backing-up-sql-server-databases-is-easier-in-powershell-than-t-sql
-
Querying SQL Server Agent Job History Data
https://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/
-
SQL Server Get Job Instance Id with TSQL
https://www.sqlservercentral.com/forums/topic/job-instance-id
-
create a temp table in SQL Server that can hold the result of a stored procedure
https://dba.stackexchange.com/questions/12739/whats-the-easiest-way-to-create-a-temp-table-in-sql-server-that-can-hold-the-re
-
Truncate all tables in a SQL Server database
https://www.mssqltips.com/sqlservertip/3218/truncate-all-tables-in-a-sql-server-database/ more
-
SQL Server: Why you Should Avoid Using the @@IDENTITY Function
https://www.red-gate.com/hub/product-learning/sql-prompt/why-you-should-avoid-using-the-identity-function more
-
Enterprise Organization Users Can Use Visual Studio 2019 Community Edition If Only Using SSDT Components
BarneyL
Visitor
04-22-2019 11:15 PM
What do enterprise sized organisations who aren't allowed to use the community edition … more
-
SQL Server Data Tools
https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017
-
SQL Server Ports: Configure a Server to Listen on a Specific TCP Port
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-2017 more
-
SQL Server: TSQL Select Into with Identity
SELECT IDENTITY(INT,1,1) AS ID,* INTO NewTable FROM ExistingTable more
-
Allow SQL Server Agent jobs management for non sysadmins
https://www.sqlservercentral.com/blogs/allow-sql-server-agent-jobs-management-for-non-sysadmins more
-
SQL Server: Temporary Stored Procedures
https://www.sqlservercentral.com/blogs/temporary-stored-procedures more
-
SQL Server: Enforce Encrypted Connections
To configure SQL Server to use a self-signed SSL certificate, follow below steps:
Create a self-signed certificate
Set permissions for this certificate
Configure SQL Server to use this … more
-
SQL Server Logon Trigger Examples
https://www.mssqltips.com/sqlservertip/6103/sql-server-logon-trigger-examples/ more
-
SQL Server Unit Testing: tSQLt and SQLCop
https://github.com/tSQLt-org/tSQLt
https://github.com/red-gate/SQLCop/
-
SQL Server Memory Consumption by Object
https://www.sqlserverscience.com/performance/memory-consumption-by-object/ more
-
An Intro to SQL Window Functions
https://www.toptal.com/sql/intro-to-sql-windows-functions more
-
Different ways to make a table read only in a SQL Server database
https://www.mssqltips.com/sqlservertip/2711/different-ways-to-make-a-table-read-only-in-a-sql-server-database/ more