Write-Host || Cannot invoke this function because the current host does not implement it
Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...
2017-02-01
1,465 reads
MSSQLFUN
Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,042 reads
What’s new in SQL Server 2016 installation?
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules...
2017-01-16
563 reads
Sequence – Long awaited feature
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to...
2017-01-05
473 reads
What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
401 reads
What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
370 reads
What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
446 reads
How to use DTA (Database Tuning Advisor) with Plan Cache option?
SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...
2016-12-12
2,619 reads
MSDB log file grown large – SLEEP_MSDBSTARTUP waittype
Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB...
2016-11-30
862 reads
We are Back Again..
After lots of crisis in last month, We are back again.
Sorry for inconvenience caused !
Reference : Rohit Garg (http://mssqlfun.com/)
You can find...
2016-11-15
515 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
SQL Server 2005 service fails to start
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
How to Repair Corrupt MySQL Tables
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
The Funny Dynamic SQL
Comments posted to this topic are about the item The Funny Dynamic SQL
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers