Forum Replies Created
Viewing 15 posts - 811 through 825 (of 7,499 total)
-
Reply To: Microsoft Failover Cluster Virtual Adapter - Login error
I hope this can help out
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: create CNAME in upgrade SQL server
We use DNS Aliasses for most of our sqlserver servers.
Hence connections to myco-dev-proj\Instance001 will get pointed to effectiveDevServer999\Instance001
We keep instance names unique !
When preparing an upgrade by new server installation,...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: SQL Agent Job is stuck
- did you hit the refresh button in SSMS ?
- can you see the job active in SQLAgent
...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: Service Broker not working on SQL 2019 High Availability Replica
Check: https://www.sqlservercentral.com/articles/using-database-master-keys-in-sql-server
I haven't tested SSB with AGs myself. #blush# ( because we do not use it in that way )
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: after remove TDE
because the log backup actually resets marks the log to be overwritten.
Preceding a full backup, you are sure that the next log backup will no longer contain encrypted log data.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: Why is my service account displaying a connection using the server IP?
only TCP/IP active ? ( Check SQL Server 20** Configuration Manager / Network Configuration )
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: BCP error "Copy direction must be either 'in' or 'out'"
we actually need your full bcp command to figure out what's going on.
REM Create_FMT_files
bcp "[yourdb].[yourschema].[yourtableorview]" format NUL -fD:\BCP\BCPExp\yourdb_yourschema_yourtableorview.fmt -S yoursqlserver -U sqluser-P sqlpwd -n -o D:\BCP\BCPExp\yourdb_yourschema_yourtableorview_fmt.log...Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: Upgraded to SQL Server 2016. Can I change compatibility levels of the master db?
yes, you can.
ALTER DATABASE [master] SET COMPATIBILITY_LEVEL = 130
Do you have proprietary objects deployed in master db ?
if yes, can you check they are still working as...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: There and back again: From a partition number to a filegroup and vice versa
- they tie together, right
/* https://docs.microsoft.com/en-us/sql/relational-databases/partitions/create-partitioned-tables-and-indexes */
-- Creates a partition function called myRangePF1 that will partition a table into four partitions
CREATE PARTITION FUNCTION myRangePF1...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: There and back again: From a partition number to a filegroup and vice versa
Even opletten :
prv.value is a boundary value, left or right according to your partitioning definition.
It is the tipping point to put data in the next partition. ( in case of...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: There and back again: From a partition number to a filegroup and vice versa
-- http://www.davidemauri.it/DasBlog/CategoryView,category,Sql%20Server%202005.aspx
--create schema ALZDBA
/* Welke query(s) uitvoeren ? */
Declare @WelkeQuery int
/* 0 = alles , (1,2,3,4,5) is enkel die query */
set @WelkeQuery = 4
if @WelkeQuery in (...Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: Backing up SQL Express with batch file and SQL procedure.
You could use a scheduled task to run this Powershell script
( save it as e.g. C:\Powershell\SQLServer_Backup_Full.ps1 )
<#
Create sqlserver backup for all databases of the local default instance
Johan...Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: consolidate error logs
Check todays featured atricle "Monitor SQL Server Error Logs with PowerShell" to get you started
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: How to prevent a sore throat after hours of presenting ppt ?
do not drink e.g. orange juice as it is very sour and sweet which is bad for your voice.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
-
Reply To: how to configure Database Mirroring in SQL Server 2008
Database Mirroring in SQL Server 2008
SQL Server 2008 R2 Database Mirroring with Automatic Failover Across the Internet
It may be a bit late to start it all in 2021...
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 811 through 825 (of 7,499 total)