Contents tagged with sql server
-
SQL Server Find Object Dependencies
https://docs.microsoft.com/en-us/sql/relational-databases/tables/view-the-dependencies-of-a-table?view=sql-server-2017#TsqlProcedure
https://www.mssqltips.com/sqlservertip/2999/different-ways-to- … more
-
SQL Server Scalar Functions
https://www.red-gate.com/simple-talk/sql/sql-training/tsql-user-defined-functions-ten-questions-you-were-too-shy-to-ask/#fifth more
-
SQL Server Contained Databases
https://mssqlexperiments.wordpress.com/2014/01/04/contained-database-concepts-and-experiments/ more
-
SQL Server: Troubleshoot xp_cmdshell
http://www.sqlpanda.com/2011/10/trouble-shooting-xpcmdshell.html
https://www.techtalkz.com/threads/granting-xp_cmdshell-permission-to-sql-login.190618/
-
SQL Server: Query the System Catalog
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/querying-the-sql-server-system-catalog-faq?view=sql-server-2017
https://dataedo.com/blog/useful-sql-server-data- … more
-
Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"
To work around this problem, open a command prompt, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"
Note … more
-
SQL: Merge Statement
https://stackoverflow.com/questions/14806768/sql-merge-statement-to-update-data more
-
SQL Server: Deleting Files with TSQL
http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx
https://stackoverflow.com/questions/43269779/how-to-delete-files-on-the-directory-via-ms-sql- … more
-
SQL Server Execute Stored Procedures in Parallel
https://www.codeproject.com/Articles/67499/Execute-Stored-Procedures-in-Parallel
http://www.sql-server-performance.com/forum/threads/asynchronous-execution-multithreaded.13249/
https://dba. … more
-
SQL Server - Grant Execute On All Stored Procedures
GRANT EXECUTE TO [MyDomain\MyUser]
https://stackoverflow.com/questions/9321334/grant-execute-to-all-stored-procedures
-
SQL Server 2012 T-SQL – EXECUTE WITH RESULT SETS
https://www.itprotoday.com/sql-server-2012-t-sql-glance-execute-result-sets
-
Introduction to PowerShell with SQL Server Using Invoke-SQLCMD
https://www.red-gate.com/simple-talk/sysadmin/powershell/introduction-to-powershell-with-sql-server-using-invoke-sqlcmd/ more
-
SQL Server vs SQL Azure
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-features
https://docs.microsoft.com/en-au/azure/sql-database/sql-database-transact-sql-information
https://ballardchalmers.com/2018/0 … more
-
SQL Server And Python
https://www.mssqltips.com/sqlservertutorial/9073/sql-server-2017-and-python-basics/
https://www.sqlshack.com/get-python-sql-server-2017/
https://wiki.python.org/moin/SQL%20Server
https://blogs. … more
-
SQL Server Autonomous Transaction Within View
/* create a function that inserts to a table via xp_cmdshell */
CREATE FUNCTION dbo.fn_write_to_table()
RETURNS int
AS
BEGIN
DECLARE @sql varchar(MAX), @cmd varchar(4000)
SELECT @sql = ' … more
-
SQL Server: Show Row Number
select ROW_NUMBER() over (order by (select 1)) as rownum, * from sys.all_objects
-
Creating Native Web Services in SQL Server (Now Deprecated)
https://www.codeproject.com/Articles/195508/Consuming-a-Web-Service-created-through-Sql-Server
https://dba.stackexchange.com/questions/159755/how-to-create-soap-endpoint-in-sql-server-2016
https:// … more
-
SQL Server From .Net: Building a DataSet with Code
http://www.sqlservercentral.com/articles/ADO.NET/171331/?utm_source=SSC&utm_medium=pubemail
-
T-SQL code for TOP N Worst Performing Stored Procedures
T-SQL code for TOP N Worst Performing Stored Procedures
-- ============================================================
-- Author: Eli Leiba
-- Create date: 2018-02
-- Description: … more
-
How to Programmatically Identify When Your SQL Server Was Last Started
https://www.databasejournal.com/tips/how-to-programmatically-identify-when-your-sql-server-was-last-started.html